ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Is there an add-in that will lock the cells like later versions of Excel? (https://www.excelbanter.com/new-users-excel/75728-there-add-will-lock-cells-like-later-versions-excel.html)

Marc

Is there an add-in that will lock the cells like later versions of Excel?
 
I'm using 97 and for 99.9% of everything I do I works fine except I can't
lock cell format so there can only be data entry. I would be nice if I
could do that.

Marc



David McRitchie

Is there an add-in that will lock the cells like later versions of Excel?
 
Hi Marc,
Can you be more specific about what you want and don't want.

"Marc" wrote in message nk.net...
I'm using 97 and for 99.9% of everything I do I works fine except I can't
lock cell format so there can only be data entry. I would be nice if I
could do that.

Marc





Marc

Is there an add-in that will lock the cells like later versions of Excel?
 
I've set the borders, the fill color etc. I want to be able to enter data
but if I need to clear, copy and cut the formatting is unaffected.

Marc


"Marc" wrote in message
nk.net...
I'm using 97 and for 99.9% of everything I do I works fine except I can't
lock cell format so there can only be data entry. I would be nice if I
could do that.

Marc






All times are GMT +1. The time now is 02:09 AM.

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