Worksheets("MySheet").Unprotect password:="drowssap"
'your code here
Worksheets("MySheet").Protect password:="drowssap"
Be sure to protect your macro code to hide the sheet password.
All of a sudden, when I open the file, it asks if I want to "Enable or Disable a Macro". There are no macros in this workbook?
My Stop Recording toolbar has disappeared. How do I get it back?
Can I have my Macro make Excel NOT ask "the file already exists, do you want to overwrite" type of questions?
I have a user defined function that does not recalculate?
Can I ask my user for confirmation before executing the macro?
I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1?
When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?
How do I run a macro every time a certain cell changes its value?
I want to show a userform each time my file is opened?
Is there a way to protect the macros I create so people can not see or alter them?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
