SelinaR
Board Regular
- Joined
- Feb 2, 2012
- Messages
- 65
- Office Version
- 2021
- Platform
- Windows
- Mobile
- Web
Afternoon boffins...
I have recorded a macro to hide and unhide a column, however I need to supercharge it...
MACRO:
On Sheet 2, to hide & another to unhide Column "U"
1. Hide column U
2. Unhide column U with a password... (hiding column & protecting the sheet wasn't a viable option)
I would also prefer a keyboard shortcut ctrl+h (hide) and ctrl+s (show) rather than a button (if possible)
I have tired a few examples on the site, but get run time errors and issues.
thanks in advance....
I have recorded a macro to hide and unhide a column, however I need to supercharge it...
MACRO:
On Sheet 2, to hide & another to unhide Column "U"
1. Hide column U
2. Unhide column U with a password... (hiding column & protecting the sheet wasn't a viable option)
I would also prefer a keyboard shortcut ctrl+h (hide) and ctrl+s (show) rather than a button (if possible)
I have tired a few examples on the site, but get run time errors and issues.
thanks in advance....