Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default prevent user from deleting a tab prevent running macro from menu

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default prevent user from deleting a tab prevent running macro from menu

#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




joemeshuggah wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default prevent user from deleting a tab prevent running macro from menu

1. deleting a specific tab in a workbook? PROTECT the workbook.

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)? Maybe you could tweak the macro
to ensure it's being run on the correct worksheet. To prevent it from the
tools menu can be a bit complicated.
--
HTH,

Barb Reinhardt



"joemeshuggah" wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default prevent user from deleting a tab prevent running macro from me

solution 2 works great...thanks!

solution 1 though i am still not sure on. i have a macro in the workbook
that adds sheets. i added made the structure protection false before the
macro adds the sheets, and then true after the sheets are added. however,
the user needs to have the ability to delete or rename the sheets that were
added in the macro. is there a way around this?

"Dave Peterson" wrote:

#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




joemeshuggah wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!


--

Dave Peterson
.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default prevent user from deleting a tab prevent running macro from me

Give them a macro or several macros that do exactly what you want. Otherwise,
you'll find that sheets you don't deleted will be gone.

joemeshuggah wrote:

solution 2 works great...thanks!

solution 1 though i am still not sure on. i have a macro in the workbook
that adds sheets. i added made the structure protection false before the
macro adds the sheets, and then true after the sheets are added. however,
the user needs to have the ability to delete or rename the sheets that were
added in the macro. is there a way around this?

"Dave Peterson" wrote:

#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




joemeshuggah wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!


--

Dave Peterson
.


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default prevent user from deleting a tab prevent running macro from me

thanks again!

i believe i was able to get around it by having the new sheets created in a
new workbook.

"Dave Peterson" wrote:

Give them a macro or several macros that do exactly what you want. Otherwise,
you'll find that sheets you don't deleted will be gone.

joemeshuggah wrote:

solution 2 works great...thanks!

solution 1 though i am still not sure on. i have a macro in the workbook
that adds sheets. i added made the structure protection false before the
macro adds the sheets, and then true after the sheets are added. however,
the user needs to have the ability to delete or rename the sheets that were
added in the macro. is there a way around this?

"Dave Peterson" wrote:

#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




joemeshuggah wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!

--

Dave Peterson
.


--

Dave Peterson
.

Reply
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
Can I prevent a user from running a macro? Michelle Excel Programming 4 November 30th 08 02:10 PM
hide/protext auto_open code so user can't prevent it from running Scott Excel Programming 4 May 18th 07 04:40 PM
How do I prevent unintentionally running a Macro? UA_Jeremy Excel Programming 1 September 8th 06 10:51 PM
Prevent user deleting an XLS file helmekki[_125_] Excel Programming 3 January 30th 06 05:29 AM
Prevent User from Deleting Drawn Object Tod Excel Programming 4 July 23rd 04 09:59 AM


All times are GMT +1. The time now is 02:43 PM.

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

About Us

"It's about Microsoft Excel"