GordonP
04-14-2008, 07:44 AM
Hi all,
I need help with combining macros and I hope someone out there can put me out of my misery!
I need to write to a macro that when a name is entered into a field, it creates or unhides a worksheet. Also is it possible to combine a macro to do all this at once:
Create sheet & update tab with name entered in cell
The unhidden/created sheet will have a question set of either 5 or 10 (The column range will be 10 or 20 columns) and I need to define by cell entry the numbers of questions that should appear.
I hope this makes sense!
Thanks in advance:banghead:
I need help with combining macros and I hope someone out there can put me out of my misery!
I need to write to a macro that when a name is entered into a field, it creates or unhides a worksheet. Also is it possible to combine a macro to do all this at once:
Create sheet & update tab with name entered in cell
The unhidden/created sheet will have a question set of either 5 or 10 (The column range will be 10 or 20 columns) and I need to define by cell entry the numbers of questions that should appear.
I hope this makes sense!
Thanks in advance:banghead: