Re: command button on form to open sheets

Talking about a UserForm in VBA or a form that you just created in a
worksheet? By Sheet do you mean a worksheet within the current
workbook, or do you meen a separate workbook?
If a UserFrom:
Sheets("ThisSheet").Activate will activate the sheet called
"ThisSheet"
Workbooks.Open "C:\ThisWorkbook.xls" will open the workbook in the C:\
dirve called "ThisWorkbook".

If you are referring to a form on a worksheet, then the same code can
be applied. Just right click on the command button in your shet and
select Assign Macro.
gbpg wrote:
Can I simply use a hyperlink to open a sheet from a command button on a form?
I don't see how to do this? Is there any code out there to do this?

.

Relevant Pages

  • RE: Need a Macro
    ... Dim lngPgRef As Long ... The above line uses the VBA string variable in lieu of an actual string. ... Don’t confuse VBA variables with named ranges on a worksheet. ... Rows.Count is a variable that hold the total number of rows on the sheet ...
    (microsoft.public.excel.programming)
  • Re: Hello, is this message visible?
    ... This is only one workbook titled March 2008. ... Master to a new worksheet with a new name, I need the new worksheet to add ... Names, sheet names, cells, etc... ...
    (microsoft.public.excel.misc)
  • Re: excel process problem 2
    ... Thisworkbook and paste in to a text file. ... Start a new workbook, go to VBE. ... > 3) any vba example of password box when open the workbook and the ... > Below code gets a valid sheet no. from the user and transfers contents ...
    (microsoft.public.excel.programming)
  • Re: Data Validation
    ... Since it's working now, with the new version of the worksheet, I'd make a few backup copies! ... What I have is is a time sheet workbook for as many employees as one would like to track. ... This is where the data validation is, to select the shift, then with a countif formula I get the totals for each. ...
    (microsoft.public.excel.misc)
  • Re: How do I code a "self-destruct" triggered after a certain date?
    ... enable macros when the workbook is opened then the code will not kick in. ... a blank sheet and deletes all the other sheets. ... Private Sub Workbook_Open ... Dim m As Date, ws As Worksheet ...
    (microsoft.public.excel.programming)