Macro to lock in 14 views on a worksheet
 

No. Look at step 5.
If you follow step 1 to 4, you just need to copy the already done combobox to other sheets and it will adjust automatically to other sheets. No extra work.
--
Regards,
Sébastien

"Steve" wrote:

Yes, I've tried that, but it only applies to one worksheet in the workbook... not all 20 worksheets.... :(

Macro to lock in 14 views on a worksheet
 

Works perfectly! Thanks very very much for your time and advice!

"sebastienm" wrote:

(and by the way, you shouldn't have to re-do any other step if you only change this part from part1)
--
Regards,
Sébastien