У нас вы можете посмотреть бесплатно Macro to hide or unhide shapes or graphical objects in Excel или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
Sometimes, due to many object or shapes on the sheet, it becomes difficult to focus on data and it becomes annoying! Now you have a quick solution to that problem! In this video, we show you how you can record a macro to quickly hide or unhide shapes or graphical object in the active sheet. You need not moving the shapes to other location to look at your data. Just click a button and you are done. Important thing is that macro must be recorded in the Personal Macro Workbook so that it is available for all the workbooks. You can then add a button to quick access toolbar and assign the macro to it. That button will always be visible in all the workbooks, and you can use this macro anytime. You can do this even if you don't know VBA; it is really simple but can save a lot of time and efforts and keep the objects as they are. Thanks!