Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macro List - Using Shortcut Key
I'm trying to hide the macro list from users but I still want to be able to
use a shortcut key on a few macros. For instance, I have a macro with an assigned short-cut that "Prepares the Workbook for Development" by unhiding and unprotecting all sheets. Hitting the short cut key fires the Sub to "Prepare for Development". Hitting the shortcut a second time "Prepare For End-users" by hiding certain sheets and protecting certain sheets. I don't want to assign this to a button (unless there is no other way.) When I use a dummy argument on the Sub name as in Sub SubName (Optional FakeArg As [type]) hitting the short-cut key pops up the macro list expecting me to pick the appropriate macro. Any ideas? Thanks - John Michl www.johnmichl.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macro List - Using Shortcut Key
Private Sub Whatever()
End Sub -- Regards, Tom Ogilvy "John Michl" wrote in message ... I'm trying to hide the macro list from users but I still want to be able to use a shortcut key on a few macros. For instance, I have a macro with an assigned short-cut that "Prepares the Workbook for Development" by unhiding and unprotecting all sheets. Hitting the short cut key fires the Sub to "Prepare for Development". Hitting the shortcut a second time "Prepare For End-users" by hiding certain sheets and protecting certain sheets. I don't want to assign this to a button (unless there is no other way.) When I use a dummy argument on the Sub name as in Sub SubName (Optional FakeArg As [type]) hitting the short-cut key pops up the macro list expecting me to pick the appropriate macro. Any ideas? Thanks - John Michl www.johnmichl.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macro List - Using Shortcut Key
Thanks, Tom.
Is it true that if I use the Private statement, this sub cannot be called by other subs? - John "Tom Ogilvy" wrote in message ... Private Sub Whatever() End Sub -- Regards, Tom Ogilvy "John Michl" wrote in message ... I'm trying to hide the macro list from users but I still want to be able to use a shortcut key on a few macros. For instance, I have a macro with an assigned short-cut that "Prepares the Workbook for Development" by unhiding and unprotecting all sheets. Hitting the short cut key fires the Sub to "Prepare for Development". Hitting the shortcut a second time "Prepare For End-users" by hiding certain sheets and protecting certain sheets. I don't want to assign this to a button (unless there is no other way.) When I use a dummy argument on the Sub name as in Sub SubName (Optional FakeArg As [type]) hitting the short-cut key pops up the macro list expecting me to pick the appropriate macro. Any ideas? Thanks - John Michl www.johnmichl.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macro List - Using Shortcut Key
Other subs in other modules, problem. Other subs in the same module, no
problem. -- Regards, Tom Ogilvy "John Michl" wrote in message ... Thanks, Tom. Is it true that if I use the Private statement, this sub cannot be called by other subs? - John "Tom Ogilvy" wrote in message ... Private Sub Whatever() End Sub -- Regards, Tom Ogilvy "John Michl" wrote in message ... I'm trying to hide the macro list from users but I still want to be able to use a shortcut key on a few macros. For instance, I have a macro with an assigned short-cut that "Prepares the Workbook for Development" by unhiding and unprotecting all sheets. Hitting the short cut key fires the Sub to "Prepare for Development". Hitting the shortcut a second time "Prepare For End-users" by hiding certain sheets and protecting certain sheets. I don't want to assign this to a button (unless there is no other way.) When I use a dummy argument on the Sub name as in Sub SubName (Optional FakeArg As [type]) hitting the short-cut key pops up the macro list expecting me to pick the appropriate macro. Any ideas? Thanks - John Michl www.johnmichl.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo box list shortcut | Excel Discussion (Misc queries) | |||
Keyboard Shortcut for Drop Down List | Excel Worksheet Functions | |||
Keyboard shortcut for List Box | Excel Worksheet Functions | |||
Shortcut key for dropdown list? | Excel Discussion (Misc queries) | |||
Hiding macro | Excel Programming |