LinkBack URL
About LinkBacks
Dear Excel Expert,
Is there any way where I can used my macro-enabled sheet while locking certain cells in my excel sheet?
Attached is part of my macro VBA code, thanks for your advise!
Please Login or Register to view this content.
HELP NEEDED: How to enabled macro with locked cells
Dear Excel Expert,
Is there any way where I can used my macro-enabled sheet while locking certain cells in my excel sheet?
Attached is part of my macro VBA code, thanks for your advise!
Please Login or Register to view this content.
Last edited by Fotis1991; 05-29-2014 at 05:39 AM. Reason: pls use code tags around your codes!!
unprotect it to run macro then protect it when the macro is finished.
use: ActiveSheet.unprotect
if password use ActiveSheet.unprotect password="mypassword"
Please Login or Register to view this content.
Shelton A.
If Helpful, Add Reputaion!
Dear fren, it works!
Thanks for your help! Much appreciate that...
By the way, can anyone tell me how to close this thread since it has been solved?
Thread tools in the top menu, and selected solved.Originally Posted by joeyjee
Thanks Aris! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks