question about saving

[Ken Stone]

I have an excel worksheet that I use to prepare a weekly work schedule.
It contains popup menus that I use to select certain variables such as
dates, times and people. Once I have a weekly schedule set, I want to
distribute it electronically but without the popup menus being active.
How can I do this?

thanks
ken

 

[Max]

Assuming the "popup menus" are data validation (DV) lists,
try this to find / kill all DVs in the sheet at one go

Press F5 > Special > Check "Data validation > All "> OK
(above will select all cells with DVs in the sheet)

Then click Data > Validation

Answer OK to the prompt below (if it opens):
"The selection contains more than one type of validation
Erase current settings and continue"

Then in the DV dialog, click "Clear All" > OK

 

[Ken Stone]

Thanks!
ken

Assuming the "popup menus" are data validation (DV) lists,
try this to find / kill all DVs in the sheet at one go

Press F5 > Special > Check "Data validation > All "> OK
(above will select all cells with DVs in the sheet)

Then click Data > Validation

Answer OK to the prompt below (if it opens):
"The selection contains more than one type of validation
Erase current settings and continue"

Then in the DV dialog, click "Clear All" > OK

 

[Max]

You're welcome !