Hello. I have spent a good deal of time to format a worksheet with particular fonts, sizes and borders. I do not want this format to change when others in my office use the file to enter data (sometimes copy & paste) into the cells. How can I protect only the format of a worksheet?
Thank you.
Hello telcocook,
Please try the attached sample Workbook.
All you need to do, is to change the Code to refer to your specific Sheet where you would like it to work.
Hope that helps.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Cool! Thank you very much for sharing that sample file Winon.
Hello telcocook,
You are welcome, glad I could help.
Thank you for adding to my Reputation.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks