Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 24th 08, 04:29 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 1
Default what is the formula for print excel sheet with an enterr

dear all
i maked a excel work sheet. i ned a print out of sheet 1 thats
automatically or with an enter. so irequired a formula or setup.
thanks
nidhin

  #2   Report Post  
Old September 24th 08, 09:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default what is the formula for print excel sheet with an enterr

Although not with an enter, you can create a macro - Tools - Macro - Record
New Macro.

Set the hotkey by entering a value after the CTRL+.

Print the page and stop recording

Now, every time you hit CTRL+ your key, it'll print the page for you.

"excel setup" wrote:

dear all
i maked a excel work sheet. i ned a print out of sheet 1 thats
automatically or with an enter. so irequired a formula or setup.
thanks
nidhin

  #3   Report Post  
Old September 24th 08, 11:39 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default what is the formula for print excel sheet with an enterr

You would need VBA code to print a sheet upon an event.

Formulas can only return values.

A macro to print the active sheet.

Sub print_activesheet()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

Event code to print the sheet when you double-click on A1

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Cancel = True
End Sub


Gord Dibben MS Excel MVP


On Tue, 23 Sep 2008 20:29:00 -0700, excel setup <excel
wrote:

dear all
i maked a excel work sheet. i ned a print out of sheet 1 thats
automatically or with an enter. so irequired a formula or setup.
thanks
nidhin




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I print my whole excel sheet? sonia Excel Discussion (Misc queries) 1 November 3rd 06 12:51 AM
Is there a formula which will print the sheet name in Excel? jhow Excel Discussion (Misc queries) 2 February 6th 06 09:30 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
Why do I get a print error light trying to print an excel sheet ? SMC Excel Discussion (Misc queries) 2 November 5th 05 01:36 AM
How do I copy a print format from sheet to sheet in excel ? kernat Excel Discussion (Misc queries) 1 July 22nd 05 04:59 PM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017