Macro shorcut Ctrl+Shift+Z no longer works

tsheffer

New Member
Joined
Sep 16, 2013
Messages
16
We have numerous macros in personal.xlsb for years with shortcut keys. Recently shortcut Ctrl+Shift+Z , that protects each sheet in a workbook, quit working for some users.
The macro runs fine when run sub/userform from VBA. With it working for some users, was thinking it was might have been an update but can find no reference to it on the internet. Removed the lastest update and that didn't make a difference.

We have tried renaming the macro and creating a new module which didn't work. We can assign another shortcut key and that works.
While that seems like the easy answer, we have limited shortcut keys available due to the numerous macros being used.

Has anyone else run into this?


Code copied from the internet:

Sub ProtectSheets()
'
' ProtectSheets Macro
'
' Keyboard Shortcut: Ctrl+Shift+Z
'Sub Protect_sheets()

Dim wSheet As Worksheet
Dim Pwd As String

Pwd = InputBox("Enter your password to protect all worksheets", "Password Input")
For Each wSheet In Worksheets
wSheet.Protect Password:=""
Next wSheet

End Sub
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,550
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Perhaps some other routine has been set to use that shortcut key combination.
 

tsheffer

New Member
Joined
Sep 16, 2013
Messages
16
Thought maybe something was set with an update but am unable to find what/where it might be.
 

Forum statistics

Threads
1,143,689
Messages
5,720,310
Members
422,275
Latest member
Maria95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top