Can't Edit Macro From Personal Workbook

jondavis1987

Active Member
Joined
Dec 31, 2015
Messages
316
When i try to edit macro it says can't edit macros from a hidden workbook. The workbook in XLStart is not hidden. I've also checked to make sure it's not in the disabled add-ins list. If i click in macros and hit run the macros will run. But i can not edit them to assign a shortcut key.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
On the view tab select Unhide & then select the personal workbook.
You should then be able to assign short-cut keys.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,099,140
Messages
5,466,915
Members
406,507
Latest member
annemiranda8

This Week's Hot Topics

Top