Preventing the Macro record facility

P

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,047
I seem to have a problem with people recording hundreds of macros (which don't do anthing useful) with the code being less then effecient its causing unecessary slowness. I have just removed 50 odd useless modules...which in itself takes a while. Does anyone know if there is a way to prevent the Macro record button from working ??

Thanks
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
You have people in your office who know how to records macros?! :eeek:

Luckily people in my office think a macro is some kind of Apple device! :biggrin:

Do they need to be able to use other Macro's that have been created for them? If not you could always disable VBA? http://support.microsoft.com/kb/282847
 
Upvote 0
Yeah they have learned how to and now use it like its going out of fashion. Unfortunately I want them to just use the one macro I have written, so I wouldn't be able to disable VBA completely

Cheers
Paul
 
Upvote 0
Nightmare, letting idiots loose on a macro recorder is like letting kids on too much sugar loose in a glass shop... dangerous. :laugh:

What version of Excel are you on?
 
Upvote 0
Indeed, everytime I remove a swathe of modules someone! goes and records hundreds more, its like grafitti, the more you get rid of it, the more it comes back, so I'm aiming to nip it in the bud.....hopefully

Im on version 2003
 
Upvote 0
Well I found this:
http://www.rondebruin.nl/menuid.htm#Menu

Which you should be able to find a way to disable the macro recorder from, it has some examples on there of disabling other functions so fingers crossed!

I am SO glad I don't have to worry about willy-nilly macro recording! :)

I feel for you! Good luck! :biggrin:
 
Upvote 0
Could always just cut off their fingers? Fairly drastic but effective solution no?
 
Upvote 0
Good idea, saves me coding. Possibly messy though, so thought about an electical discharge once they select Macro Record...just can't think of a way of programming that ?!?!?
 
Upvote 0
Link it to a hidden taser?
Code: 
Application.ExternalDevice.Enable = True
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Hide userform title bar, and locking the userform into a relative position on the application.
2
Replies
16
Views
980
Jaafar Tribak
Jaafar Tribak
Dan Wilson
  • Question Question
Macro Help
Replies
8
Views
247
Dan Wilson
Dan Wilson
X
  • Question Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
619
KRice
K
M
  • Solved
VBA Help - Duplicate & Unwanted Data Removal
Replies
6
Views
1K
MoonDancer
M
T
  • Question Question
Automatically Copying Data To A New Workbook When Closing A Workbook
Replies
4
Views
502
Tmini
T

Forum statistics

Threads
1,225,516
Messages
6,185,445
Members
453,289
Latest member
ALPOINT_AIG

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