New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Restrict deletion of sheets with VBA

Macros, VBA, Excel Automation, etc.

Restrict deletion of sheets with VBA

Postby Poojapriya17 » Wed Oct 14, 2015 2:19 am

Hello all,
Is there any possible to restrict the user from deleting the sheets in excel vba ?. I don't want to disable the right click and protect the sheet (i.e,) User's are allowed to perform other operations except deletion.
Does anyone have idea to solve this?
Thanks in advance!
  • 0

Poojapriya17
Rookie
 
Posts: 1
Joined: Oct 14, 2015
Reputation: 0
Excel Version: 2010

Re: Restrict deletion of sheets with VBA

Postby NoSparks » Wed Oct 14, 2015 8:37 am

In your search for a solution, did you happen to come across this page.
Some very well respected Excel people working and commenting on this.
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 240 guests