Hide & Load User Form

A

adamsm

Active Member
Joined
Apr 20, 2010
Messages
444
Hi anyone,

How could I write a macro code that would hide the rows D2:D168, if any of them is hidden & load the form.

If the rows are hidden I want the code to only load the form.

Any help on this would be kindly appreciated.

Thanks in advance.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
290
Jaafar Tribak
Jaafar Tribak
P
  • Question
Checking If a listbox has a row selected
Replies
5
Views
176
Pacman52
P
netspeedz
  • Solved
Load Image in User Form - 64bit Excel [VBA]
Replies
6
Views
374
netspeedz
netspeedz
D
  • Question
Set form's listbox ColumnWidths before loading rows
Replies
1
Views
158
drag1c
D
S
  • Solved
Using User form to load workbook, extract and combine desired data into new workbook or worksheet
2
Replies
10
Views
360
mumps
mumps

Forum statistics

Threads
1,214,926
Messages
6,122,305
Members
449,079
Latest member
juggernaut24

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top