Create hyperlink for those particular sheets. I feel it will help you out.
Regards
kumar
On 1/19/09, VIRAL PANDYA wrote:
> Plz plz plz help me out.
>
>
>
> On 1/18/09, VIRAL PANDYA wrote:
>>
>> Dear All,
>>
>> I have a excel sheet contains 128 Sheets and daily i have to take print
>> out
>
If all you want to do is print a few sheets from your workbook. Try the
following :
Public Sub PrintSomeSheets()
Dim FileName As String
Application.ScreenUpdating = False
FileName = "C:\Accounting\Reports\Budget.xls"
Workbooks.Open FileName, , True
With Workbooks(FileName)
u can use Hyperlink to link those 5 sheets
On Sun, Jan 18, 2009 at 6:31 PM, VIRAL PANDYA wrote:
> Dear All,
>
> I have a excel sheet contains 128 Sheets and daily i have to take print out
> only for 5 Sheet (record sheets).
>
> Is there any way by which i can create a linked excel file for onl
Plz plz plz help me out.
On 1/18/09, VIRAL PANDYA wrote:
>
> Dear All,
>
> I have a excel sheet contains 128 Sheets and daily i have to take print out
> only for 5 Sheet (record sheets).
>
> Is there any way by which i can create a linked excel file for only this 5
> sheets?
>
> Please help
