Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I actually have two questions. I have, tried, to create a macro in "This Workbook", when I became dissatisfied with it I simply deleted it. The problem is even though this macro does not exist in "This Workbook" I still get a prompt (when opening) that asks if I want to enable macro's. Q1: How can I eliminate this? The reason I tried to eliminate it is I recorded the macro that was supposed to, unprotect the workbook / unhide a page, the macro is erroneous though; it looks like this: ' Keyboard Shortcut: Ctrl+Shift+U ' ActiveWorkbook.Unprotect Sheets("2005 Summary, Exhaustive").Visible = True End Sub The macro would work perfectly if when I hit the shortcut key's it would: unprotect the workbook / unhide a sheet named "2005 Summary, Exhaustive" / and automatically return the protection settings back when the user closes the file. Q2: Can this be done, if so how? Thanks for any help! -- Thank you, Trying Hard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |