I want to disallow users from double clicking to rename worksheet tabs. Is there any way of doing this?
I want to disallow users from double clicking to rename worksheet tabs. Is there any way of doing this?
Hi,
"You could use tools/protection/protect workbook/structure. Or you could
check out Code Names in VBA help - they can be used regardless of the
tab name."
VBA Noob
Hi
As VBA Noob suggested
Sub auto_open()
ActiveWorkbook.Protect Structure:=True, Windows:=False, Password:="Denis"
End Sub
Thank you guys! It's working perfectly![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks