Home » Forums » Open Source Learning Center » Question and Answer

VBA Code help

Submitted by umesh_pede2002 on 9 July, 2014 - 11:21

Hello,
I have created two userform. one is with3-4 command buttons & another is multipage form. i want code for userform 1 when i click on command1 it should automatically go to page 2of usrform 2. can somebody plz help me with this

‹ need to parse out a field with multiple items in field 3rd Percentile Formula ›
»

copy and save specific excel sheets to a new workbook as values

Submitted by mohsaloum on 22 July, 2014 - 08:09.

how to copy used range of 3 sheets from active workbook to a new 3 sheets in a new workbook and paste as values and formats without formulas with same sheets names for the new workbook set all cells in all sheets locked, protect all sheets with password with all allowing unchecked, protect workbook with password, save the new workbook with file name containing current date and time to a fixed directory, (i.e.: c:\bill) with open password.

»