Hey, I have a table in which the first row of cells are headings for each column and can sort data from all the columns. On the second row are the totals of all the columns The simplest (read "low-tech) way is to periodically lock the data for previous months in the DetailSheet. Select the range of cells you want to "lock" and CTRL
Join Date 10-10-2012 Location Toronto, Canada MS-Off Ver Excel 2010, 365 Posts 8,023 I need to do this for around 100 different cells, and then change the lock on them. Is there a quick way I can lock multiple cells in the same way, rather than going
Hey, I have a table in which the first row of cells are headings for each column and can sort data from all the columns. On the second row are the totals of all the columns
The simplest (read "low-tech) way is to periodically lock the data for previous months in the DetailSheet. Select the range of cells you want to "lock" and CTRL
Join Date 10-10-2012 Location Toronto, Canada MS-Off Ver Excel 2010, 365 Posts 8,023
I need to do this for around 100 different cells, and then change the lock on them. Is there a quick way I can lock multiple cells in the same way, rather than going
Re: Lock all cells in a worksheet but allow rows to be deleted Hi, Winon, maybe use UserInterfaceOnly:=True for protecting the sheet when activating and then use any VBA
How To Lock Cells In Excel Browser - The pictures related to be able to How To Lock Cells In Excel Browser in the following paragraphs, hopefully they will can be useful and will increase your knowledge. Appreciate you for making the effort to be able to visit our website and even read our articles. Cya ~.
RSS Feed | Sitemaps
Copyright © 2025. By Europedias