Jul 11 2022 12:15 AM
is it possible to hide rows in excel 365 based on the content of a specific cell?
Jul 11 2022 03:46 AM
Yes; it would require VBA code.
Can you provide more detailed information?
Jul 11 2022 04:12 AM
Do you see an area below the reply box with "Drag and drop here or browse file to attach"? If so, drag your workbook into that area.
Otherwise, you can upload the workbook to a cloud service such as OneDrive, Google Drive or Dropbox, share it and post a link to the shared file in your reply.
Jul 11 2022 04:29 AM - edited Jul 11 2022 04:32 AM
I have three pages in the “Sheet1” of the "test3" excel file, I need to create four buttons to:
Jul 11 2022 04:39 AM
Where do you want the buttons? We can't place them next to one of the three pages because they might be hidden?
Jul 11 2022 04:41 AM - edited Jul 11 2022 04:42 AM
ca you put it at the first row starting from C1 before the row of student name and degree?
Jul 11 2022 04:47 AM
But buttons 2 and 3 will hide page 1...
Jul 11 2022 04:49 AM
Jul 11 2022 05:46 AM
See the attached workbook (now a macro-enabled workbook, so you'll have to allow macros).
The buttons are below page 3.
Jul 11 2022 05:58 AM
Jul 11 2022 06:35 AM
SolutionSure.
Jul 11 2022 07:30 AM
Jul 11 2022 10:29 AM - edited Jul 11 2022 11:41 AM
Good Evening
Sorry for disruption
I have applied the code with some modifications on the number only. However, I have faced some problems in specifying the page print area. I decided to send you the original file "AA enabled macro + Hidden row" and write here some notes as below:
In the "AA enabled macro + Hidden row", original file:
Also, I sent you "test5" file after applying the hidden rows code and a picture shows the problem.
Many thanks in advance
Regards
Jul 11 2022 11:59 AM
Sorry, that's too complicated for me.
Jul 11 2022 06:35 AM
Solution