How to make it possible that users can copy paste cells and cell ranges to another place on the sheet, hereby NOT copy paste Conditional Formats.
I use protected cells, users are able to select unlocked cells and are able to write contents in it.
I also have COPY command button, so VB code is welcome.
Bart
v. 2003.
See the VBA help on using the PasteSpecial(xlPasteValues) Method.
basic code example:
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks