Stop Worksheets or Entire Workbooks from Being Printed in Excel

Опубликовано: 06 Сентябрь 2022
на канале: TeachExcel
7,485
101

How to prevent a workbook from being printed, or just prevent specific worksheets from being printed in Excel.
Excel VBA/Macro Course! [On Sale]: https://www.teachexcel.com/vba-course...

This trick requires just a little VBA and Macro code but it is very easy to use.
Combine this with my tutorial on how to Force a User to Enable Macros and you can prevent certain data from being printed.

This trick will also work well with more complex requirements, such as preventing specific data from being printed or preventing charts from being printed, or requiring a password in order to print, and so much more.

Require Enabling Macros in Excel:    • Force a User to Enable Macros in Exce...  

To build powerful VBA projects or further customize this one, checkout my full VBA Course: https://www.teachexcel.com/vba-course...

Resources:
Worksheet Visible Property (msft link): https://docs.microsoft.com/en-us/offi...
Worksheet Visible Options (msft link): https://docs.microsoft.com/en-us/offi...

#msexcel #tutorial #vba #exceltips #freetutorial #exceltips #excel


Смотрите видео Stop Worksheets or Entire Workbooks from Being Printed in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TeachExcel 06 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,485 раз и оно понравилось 101 людям.