How can I Allow Users to use macros while sheet is protected

J

jfalcone1

Board Regular
Joined
Jul 13, 2007
Messages
55
I have several macro buttons on a worksheet that is protected from editing. But the protection disables the macros.

Is there a way around this?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
You can unprotect/reprotect in your code:

Code: 
ActiveSheet.Unprotect "PasswordGoesHere"
  '  Your code
ActiveSheet.Protect "PasswordGoesHere"

HTH,

Smitty
 
Upvote 0
You must log in or register to reply here.

Similar threads

SaraWitch
  • Solved
Use 'Unfilter' macro on protected sheet
Replies
2
Views
130
SaraWitch
SaraWitch
GMC The Macro Man
  • Question
Sorting a table in a protected sheet when some cells are locked -MACRO needed
Replies
3
Views
264
RoryA
RoryA
FloatedWheat
  • Question
Protect Sheet with Different User Permissions
Replies
3
Views
382
iggydarsa
iggydarsa
M
  • Question
Protecting Sheet from users but permitting Power Automate
Replies
1
Views
145
ExcelToDAX
E
J
  • Solved
Disable shapes when Workbook is protected VBA
2
Replies
12
Views
1K
mumps
mumps

Forum statistics

Threads
1,222,017
Messages
6,163,411
Members
451,835
Latest member
kristianb63

Share this page

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
Back
Top