Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Button to create a new form
I have the first three lines of my spreadsheet as a header
In row four i have column headings a-z. I want to have a button in my header that once clicked opens a form from the range 4a-4z. I have tried to make a macro but it wants to pull it from the very top and not the specified range i highlight. Is there a macro or code i need to do to do this? Thank you for any help or advice you may have. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Button to create a new form
What do you consider as a "Form"?
How did you highlight A4:Z4 when you recorded the macro? Cannot decipher what you are trying to achieve based upon your explanation. Gord Dibben MS Excel MVP On Thu, 3 May 2007 08:30:01 -0700, ihatetheredskins wrote: I have the first three lines of my spreadsheet as a header In row four i have column headings a-z. I want to have a button in my header that once clicked opens a form from the range 4a-4z. I have tried to make a macro but it wants to pull it from the very top and not the specified range i highlight. Is there a macro or code i need to do to do this? Thank you for any help or advice you may have. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
Form Button not active | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
How do I create a button on the toolbar that will start my form? | Excel Discussion (Misc queries) | |||
Form with submit button | Excel Worksheet Functions |