View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ihatetheredskins ihatetheredskins is offline
external usenet poster
 
Posts: 8
Default 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.