Is it possible to disable all macros when saving as a copy?

H

hon

Board Regular
Joined
Oct 10, 2005
Messages
73
I am trying to discourage users to make copy of the master file by disabling all the macros. Is it possible?
 
Sort by date Sort by votes
Could you be more specific on how to invoke this macro? I need it to fire when the users choose to use the option fileSaveAs.
 
Upvote 0

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
You must log in or register to reply here.

Similar threads

N
  • Question
Excel Crashes when I Save Any File
Replies
4
Views
223
nolass
N
gheyman
  • Solved
Missing Macros
2
Replies
10
Views
137
Joe4
Joe4
K
  • Question
Disabling Save button (while enabling SaveAs) NO LONGER WORKS!!! (Insert cursing emoji here)
Replies
4
Views
134
kgartin
K
S
  • Solved
Excel keeps disabling macros for only one user
Replies
8
Views
325
MARK858
MARK858
C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
320
Jaafar Tribak
Jaafar Tribak

Forum statistics

Threads
1,215,308
Messages
6,124,178
Members
449,146
Latest member
el_gazar

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