hi i need to stop the user from modifying the data once he has clicked the update button say the data is in range a1:m100 , i need a macro to somehow lock the data
hi i need to stop the user from modifying the data once he has clicked the update button say the data is in range a1:m100 , i need a macro to somehow lock the data
At the bottom of your update button code before END SUB add thiswhen the user clicks the button all the cells in the range have their Locked attribute set to true then the sheet protected with the password passwordPlease Login or Register to view this content.
Not all forums are the same - seek and you shall find
Try this, amend the sheet reference
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
brilliant.one more thing can i incoperate the lastrow thing for example from columns a through m i want to lock the cells to the point where the last data exists
for last row:
Please Login or Register to view this content.
can i lock the macro with a password because i will be providing this sheet to customers
the lastrow code is giving error application defined or object defined error
k have protected the macro too just need help with the lastrow thing
LastRow works fine for me, care to show us how you are using it?
i have fixed it i m a attaching my workbook somehow all the ranges are being locked whereas i wanted it to be a
i wanted it to be *a1:a5
here is the workbook some how all the ranges are being locked i want it to be a1:a5 only ...password is "haha"
Use this for the xpanding rangePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks