How can I hide all the formula's that I have used in my workbook using a macro?
How can I hide all the formula's that I have used in my workbook using a macro?
Hi,
if you right click the cells with the formulae, choose Format cells, in the protection window check Hidden: when you set Protection on your sheet, formulae are not visible anymore.
I don't know VBA, but I've found some instructions here:
http://www.teachexcel.com/free-excel...-deletion.html
Regards
This will lock & hide all formulas in each shet, then add sheet protection
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If you are not going to reuse the workbook but just distributing it for information purposes you could just copy and then paste back as value.
AlfPlease Login or Register to view this content.
If you want to change cells to values you don't need to activate the sheets
Please Login or Register to view this content.
Nice and short!
Thanks Roy
Alf
Tested, did not work so I had to make a small change
AlfPlease Login or Register to view this content.
This works
Please Login or Register to view this content.
Hello Roy,
Some real nifty short and sweet good coding you have posted here. I Like !
Why use "Select"?
This should work as well I think.
AlfPlease Login or Register to view this content.
Alf, look at the code. It selects the worksheets to Group them then selects all the cells on one go before converting. Your coe will only work on one sheet
Hello Roy,
Could one perhaps add to this one line of your code to include preserving formats as well?
Please Login or Register to view this content.
Ah, I missed that. Very elegant Roy!
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks