How to hide the multiple excel sheets

[pavithra_pavi]

Hi @gopal_ram ,

As @Jobin_Joy rightly pointed out, you can use VBA code to hide and unhide the sheets.

There is a video in YouTube please check out , you will get an idea. The video is basically for single sheet, but if you want to work for multiple sheet, then enclose the logic in for each loop.

Way 1 :

For each loop ---- This is for Sheets
use the workflow created in the video

Way 2:
Modify the code, by looping each sheets in VBA or vb.net

Hide Excel Sheet

Hide the Particular Excel Sheet using UiPath Hi everyone, I’m here with another interesting scenario where we want to hide particular excel sheet… There are 2 ways to achieve this 1. Using VB.NET Code 2. Using Macro in excel and calling the macro in UiPath. Watch the video to know how we can achieve these 2 and also get the code. [Hide Excel sheet using UiPath | Macro]