ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Read only lock on rows (https://www.excelbanter.com/excel-programming/293613-read-only-lock-rows.html)

eyecalibrate[_4_]

Read only lock on rows
 
When I am finished entering data in a row I hot button a macro whic
prints the data in that row. I want to include a command in the macr
which then puts a protection on the row I just printed (and maintain
protection on all the previous rows). Something on the order of "rea
only" would be excellent. If I do this will I still be able to quer
and sort?

Thanks for your help,

(I receive so much from this forum),

Eyecalibrat

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com