LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Prevent end users from manually running or recording macros

you can put something like this in a file that excel loads at startup:

Application.CommandBars("Edit").Controls("Delete.. .").Enabled = False

The above command disables the delete option under the edit menu. You can
then hide the file that excel loads at startup so that the users can't find
it to change it.

Rui

"Bill Murphy" wrote in message
...
End users can manually run macros or record new ones by selecting
Tools/Macros while in the workbook. Is there a way to password protect

the
Macros choice on this menu so that only the system administrator or other
authorized users can do this?

Bill




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I prevent users from changing macros? linto Excel Discussion (Misc queries) 1 January 6th 10 01:45 PM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
How do I make the Stop Recording bar pop up when recording macros J Excel Worksheet Functions 1 January 10th 06 08:46 PM
prevent users from overwriting other users data [email protected] Excel Worksheet Functions 0 April 17th 05 08:18 PM
Prevent users from running macros Alan Hutchins Excel Programming 7 June 2nd 04 05:12 PM


All times are GMT +1. The time now is 03:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"