Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to email image of current protected WSheet
Hi,
Is it possible & how. I would like to send a copy of the current single WS by email using a macro, the sheet is protected, and the receiver only needs to have a image meaning non fuctioning WSheet, if I send a fuctioning WS the receiver cant see all of it due to some cells being linked to others in the Wbook. any ideas welcome Repectx Laddie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to email image of current protected WSheet
Hi Laddie
To produce a single sheet workbook containing a static copy of the original worksheet, try something like: '============= Public Sub Tester() Dim WB As Workbook Dim SH As Worksheet Set WB = ThisWorkbook With WB Set SH = .Sheets("Sheet3") '<<==== CHANGE SH.Copy After:=.Sheets(.Sheets.Count) End With With SH.UsedRange .Value = .Value End With SH.Copy End Sub '<<============= To email the new workbook, see Ron de Bruin's extensive range of sample code at: Example Code for sending mail from Excel http://www.rondebruin.nl/sendmail.htm --- Regards, Norman "LaDdIe" wrote in message ... Hi, Is it possible & how. I would like to send a copy of the current single WS by email using a macro, the sheet is protected, and the receiver only needs to have a image meaning non fuctioning WSheet, if I send a fuctioning WS the receiver cant see all of it due to some cells being linked to others in the Wbook. any ideas welcome Repectx Laddie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to email image of current protected WSheet
Hi Laddie,
Replace the suggested code to produce the single-sheet workbook with the following version: '============= Public Sub Tester() Dim WB As Workbook Dim SH As Worksheet Set WB = ThisWorkbook With WB Set SH = .Sheets("Sheet3") '<<==== CHANGE SH.Copy After:=.Sheets(.Sheets.Count) End With SH.Copy With ActiveSheet.UsedRange .Value = .Value End With Application.DisplayAlerts = False With WB .Sheets(.Sheets.Count).Delete Application.DisplayAlerts = True End With End Sub '<<============= --- Regards, Norman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to email image of current protected WSheet
Thank Norman,
"Norman Jones" wrote: Hi Laddie, Replace the suggested code to produce the single-sheet workbook with the following version: '============= Public Sub Tester() Dim WB As Workbook Dim SH As Worksheet Set WB = ThisWorkbook With WB Set SH = .Sheets("Sheet3") '<<==== CHANGE SH.Copy After:=.Sheets(.Sheets.Count) End With SH.Copy With ActiveSheet.UsedRange .Value = .Value End With Application.DisplayAlerts = False With WB .Sheets(.Sheets.Count).Delete Application.DisplayAlerts = True End With End Sub '<<============= --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy row 2 of any wsheet to the new crated wsheet | Excel Worksheet Functions | |||
Macro doesn't insert image when spreadsheet is protected | Excel Worksheet Functions | |||
Macro to insert Current Time into protected cell | Excel Programming | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
Insert Image in cell B13 on Protected worksheet | Excel Programming |