|  | Can't edit/delete macro | | |
| | | Square Peg |  |
|  Posted: Sun Sep 14, 2008 3:59 pm Post subject: Can't edit/delete macro |  |
I created a macro to assign a command (Lock Cell) to a keyboard
shortcut. I need to edit the macro or delete it and rerecord it. When
I try, Excel says that it can't edit a macro on a hidden workbook.
As far as I know, the workbook is not hidden. I have protected 2-3
sheets in this workbook, but they are all currently unprotected. I
have never (intentionally) hidden the entire workbook.
How can I find it the workbook is hidden or, more importantly, how to
unhide it? |
| |
| | | Don Guillett | |
| | Posted: Sun Sep 14, 2008 4:59 pm Post subject: Re: Can't edit/delete macro | |
Sub TogglePersonal()
Windows("PERSONAL.XLS").Visible = Not Windows("PERSONAL.XLS").Visible
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:grjqc4l00sno6kdf5ihmmjkra66te4durr@4ax.com...
| Quote: | I created a macro to assign a command (Lock Cell) to a keyboard
shortcut. I need to edit the macro or delete it and rerecord it. When
I try, Excel says that it can't edit a macro on a hidden workbook.
As far as I know, the workbook is not hidden. I have protected 2-3
sheets in this workbook, but they are all currently unprotected. I
have never (intentionally) hidden the entire workbook.
How can I find it the workbook is hidden or, more importantly, how to
unhide it? |
|
| |
| | | Gord Dibben | |
| | Posted: Sun Sep 14, 2008 5:04 pm Post subject: Re: Can't edit/delete macro | |
| |  | |
Perhaps you recorded the macro in your Personal Macro Workbook and not the
current workbook?
Go to Window>Unhide and see if you have Personal.xls hidden.
If so, unhide then do your editing.
BTW.............There is a "Lock Cell" Icon under
Tools>Customize>Commands>Format
Looks like a Padlock.............move it to your Toolbar
Toggles selected cells for lock/unlock
Gord Dibben MS Excel MVP
On Sun, 14 Sep 2008 10:59:42 -0700, Square Peg <SquarePeg@Round.Hole> wrote:
| Quote: | I created a macro to assign a command (Lock Cell) to a keyboard
shortcut. I need to edit the macro or delete it and rerecord it. When
I try, Excel says that it can't edit a macro on a hidden workbook.
As far as I know, the workbook is not hidden. I have protected 2-3
sheets in this workbook, but they are all currently unprotected. I
have never (intentionally) hidden the entire workbook.
How can I find it the workbook is hidden or, more importantly, how to
unhide it? |
|
| |
| | | Square Peg | |
| | Posted: Sun Sep 14, 2008 6:09 pm Post subject: Re: Can't edit/delete macro | |
| | | |
On Sun, 14 Sep 2008 12:04:27 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:
| Quote: | Perhaps you recorded the macro in your Personal Macro Workbook and not the
current workbook?
|
Yes, I wanted it available to all workbooks.
| Quote: | Go to Window>Unhide and see if you have Personal.xls hidden.
If so, unhide then do your editing.
|
Yep, that was it.
This seems like terrible human factors.
| Quote: | BTW.............There is a "Lock Cell" Icon under
Tools>Customize>Commands>Format
Looks like a Padlock.............move it to your Toolbar
Toggles selected cells for lock/unlock
|
I just happened to discover it about an hour ago. It's now sitting
happily on my Quick Access Toolbar. I think I still want the keyboard
shortcut.
Thanks
| Quote: | Gord Dibben MS Excel MVP
On Sun, 14 Sep 2008 10:59:42 -0700, Square Peg <SquarePeg@Round.Hole> wrote:
I created a macro to assign a command (Lock Cell) to a keyboard
shortcut. I need to edit the macro or delete it and rerecord it. When
I try, Excel says that it can't edit a macro on a hidden workbook.
As far as I know, the workbook is not hidden. I have protected 2-3
sheets in this workbook, but they are all currently unprotected. I
have never (intentionally) hidden the entire workbook.
How can I find it the workbook is hidden or, more importantly, how to
unhide it? |
|
| |
|
|
