Hi
I'm creating an order input form using excel / query. My database is in a hidden sheet and my order input sheet and order form (printout) are visible sheets. I have set the data to refresh every hour but should a user need to refresh the data immediately I have created a button for this. My code for refreshing the sheet is fine when the database sheet is visible, but it doesn't work when it's hidden.
(Sorry if this is very simple - I'm quite new to vb and I'm teaching myself as I go along but can't find the answer anywhere).
Can anyone give me an example of the correct code required?
Thanks
Rowan
I'm creating an order input form using excel / query. My database is in a hidden sheet and my order input sheet and order form (printout) are visible sheets. I have set the data to refresh every hour but should a user need to refresh the data immediately I have created a button for this. My code for refreshing the sheet is fine when the database sheet is visible, but it doesn't work when it's hidden.
(Sorry if this is very simple - I'm quite new to vb and I'm teaching myself as I go along but can't find the answer anywhere).
Can anyone give me an example of the correct code required?
Thanks
Rowan