D
Don Wiss
All of my spreadsheets have similar Hide and Unhide macros. These handle
all the sheet hiding and protection. I gave the macros the shortcuts of
Ctrl-i and Ctrl-u. But if more than one spreadsheet is open, the shortcuts
don't work. Why is this? This annoys my users, as they all know and use
these shortcuts. Excel should know which is the active workbook. Is there
any way around this?
Don <www.donwiss.com> (e-mail link at home page bottom).
all the sheet hiding and protection. I gave the macros the shortcuts of
Ctrl-i and Ctrl-u. But if more than one spreadsheet is open, the shortcuts
don't work. Why is this? This annoys my users, as they all know and use
these shortcuts. Excel should know which is the active workbook. Is there
any way around this?
Don <www.donwiss.com> (e-mail link at home page bottom).