Hiding Macro List - Using Shortcut Key

[John Michl]

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

 

[Tom Ogilvy]

Private Sub Whatever()

End Sub

 

[John Michl]

Thanks, Tom.

Is it true that if I use the Private statement, this sub cannot be called by
other subs?

- John

Private Sub Whatever()

End Sub

--
Regards,
Tom Ogilvy

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

 

[Tom Ogilvy]

Other subs in other modules, problem. Other subs in the same module, no
problem.

--
Regards,
Tom Ogilvy

Thanks, Tom.

Is it true that if I use the Private statement, this sub cannot be called by
other subs?

- John

Private Sub Whatever()

End Sub

--
Regards,
Tom Ogilvy

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