Thread: Auto Hide
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Markus Grein Markus Grein is offline
external usenet poster
 
Posts: 6
Default Auto Hide


"Davo" wrote in message
...
Hi,

I want to set up my Excel form so that when the user is finished entering

the data, Excel hides columns/rows that don't have data in them. For
example, if I set it up for 10 rows, but the user only needs 4 rows, they
would hit a button (triggering a macro) and the 6 unused rows would be
hidden (or deleted.)


Hi Davo !

Do you actually want to hide/delete columns/rows that appear on a *form*
(i.e. text fields) or on a *worksheet* ?

cheers,
Markus