Free for PREMIUM members
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI then
Sheets("some sheet").Range("A2,A4,B5,C17").Interior.Colorindex = xlcolorindexnone
Open in new window
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If SaveAsUI Then
Sheets("Purchase Order").Range("C12,D12,C13,C14,C15,C16,D19,F19,H19,D21C26,D26,E26,G26").Interior.ColorIndex = xlColorIndexNone
In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!