Disable Printing Of A Worksheet

Feb 20, 2007

I have a workbook of some 15 worksheets - however there is just one of the worksheets I want to disable the printing of it. So that when users select print whole document - all worksheets will print except for thus one worksheet

The worksheet tab is named "15.ADMIN WORKBOOK CONTROL ONLY"

I know I need to put some vba code into the code area of that worksheet

I tried this code but it didnt work


Private Sub Worksheet_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

View 9 Replies


ADVERTISEMENT

Disable Users From Printing The Sheet

Jan 19, 2009

I tried to disable users from printing the sheet
with this

View 6 Replies View Related

Disable Printing In Excel Workbook That Has 3 Worksheets?

Jul 15, 2014

I am trying to disable printing in an Excel workbook that has 3 worksheets. I do want any worksheets to be able to print.

View 2 Replies View Related

Disable Worksheet Button

Jul 27, 2007

I have buttons on each of my sheets, when one is clicked code is called in my module ("modAPI"), and from that code I wish to disable and enable certain buttons, and/or change the caption of those buttons. However when I try to do:

With ws
btnRefresh.Enabled = False
End With

I get Error 424, Object Required. I've tried recording a macro of what I wish to do, and it gives me ActiveSheet.Shapes("btnRefresh").Select, but this doesn't give me the option to enabled/disable or change the caption of the button.

View 3 Replies View Related

How To Disable Worksheet Functions Within Out Protection

Jun 19, 2009

I have a spreadsheet which has extra worksheets at the end that the user can move around, if they need them.

Then i found out that users were adding there own sheets, so i protected the workbook, but i found out that this stops the user from moving the sheet.

Whats the easiest way probably using code to disable the worksheet functions, ie the ones that appear if you click on the tab (insert,delete,rename,move+copy,select all sheets etc) but still allow the user to move the sheet within the workbook

View 7 Replies View Related

Disable Close (X) On Specific Worksheet

Jan 9, 2010

I have a pivot table that's made visible from a "Drill Down" button on the source worksheet.

View 4 Replies View Related

VBA - Disable Form Checkbox In Worksheet

Jan 18, 2013

I want to have a Checkbox (Form) that is in my Worksheet to disable/gray-out once it is selected. I don't want people to be able to uncheck it again. I want them to be forced to click another Checkbox to enable it again.

Example:

Two Checkboxes:

Check Box 1 = "Apply"
Check Box 2 = "Delete"

Once "Apply" is checked, gray it out. This will force a user to click "Delete" in order for the "Apply" button to be enabled again. I do not want a user to click "Apply" once selected as their way of 'deleting' the information.

View 1 Replies View Related

Hide / Disable Worksheet Menu Bar - !

Feb 27, 2007

Is there a way to either hide or disable the worksheet menu bar on ONE SHEET ONLY, so that a right-click customize doesn't even work on that sheet. I want the user to be able to do nothing but what my customized toolbar allows on that sheet.

View 5 Replies View Related

Disable Copy/paste Within Worksheet

May 22, 2007

Is it possible to disable the copy/paste functions on a particular worksheet within a workbook, or failign that, on a complete workbook?

View 9 Replies View Related

Printing One Worksheet From Multiple Worksheets

Jul 26, 2009

I have a bunch of workbooks i need to print from a particular sheet each time, which is always called 'calculation'.

View 8 Replies View Related

Worksheet Not Accepting Printing Defaults

Aug 22, 2006

I've created a worksheet that uses multiple print macros with defined margins. This works fine with the Epson printers I have, but a user has an HP Officejet Pro K550.

This printer has an option named "Minimize Margins". If this option is checked then you adjust the margins the way you want.

For some reason when this particular workbook is opened you have to manually go and check this option so that the margins can be manipulated. this is a problem b/c my macro prints several reports so it's impossible to set this option.

I then opened a different workbook and it accepted the default setting (option checked). For some reason the workbook I created doesn't.

View 3 Replies View Related

Disable Cut / Copy / Paste And Delete In Worksheet

Oct 28, 2011

I would like to disable cut/copy/paste and maybe delete inside a worksheet. Reading earlier threads on this subject provided the code to put in the ThisWorkbook module, where it works great for all my worksheets. However, there is one worksheet where it is necessary to have copy/paste, either with control c or right click/copy. Here is part of that code provided by Tom Urtis:

Private Sub Workbook_Activate()
Application.CutCopyMode = False
Application.OnKey "^c", ""
Application.CellDragAndDrop = False
End Sub

What do I replace Application with to work on just the worksheet level?

View 2 Replies View Related

Disable Notification Of Password Protected WorkSheet

Apr 1, 2014

Is there any method to disable notification / error message of password protected sheet when we try to edit restricted cells?

Note: In my scenario I've to allow user to select protected cell; that's why cell selection redirection is not useful for my.

View 7 Replies View Related

Enable & Disable Worksheet Controls Based On ComboBox Value

Mar 5, 2008

I'm currently building an Excel database. This database has a few comboboxes and checkboxes that are tied to each other. If I select the combobox option of "Years", the "Quarters" combobox must be greyed out. In addition depending on which option is chosen, the relevant check boxes must be enabeled or disabled. I've written some code which runs fine, until I try and activate another macro button or if I add and rename a sheet(which is not linked to anything). What should I do? Here is a sample of my code. I have a feeling it's really obviouse but I cant see it..

Private Sub ComboBox2_Change()
If Sheets("InputSheet").ComboBox2 = "Years" Then
Sheets("InputSheet").ComboBox3.Value = ""
Sheets("InputSheet").ComboBox3.Enabled = False
Sheets("InputSheet").CheckBox6.Enabled = True
Sheets("InputSheet").CheckBox7.Enabled = True
Sheets("InputSheet").CheckBox8.Enabled = True
Sheets("InputSheet").CheckBox9.Enabled = True
Sheets("InputSheet").CheckBox10.Enabled = True
Sheets("InputSheet").CheckBox11.Enabled = True
Sheets("InputSheet").CheckBox12.Enabled = True
Sheets("InputSheet").CheckBox13.Enabled = True
Sheets("InputSheet").CheckBox14.Enabled = True
End If...................

View 3 Replies View Related

How To Make 2 Cells On Worksheet Be Required To Be Filled In Before Printing

Dec 19, 2011

We have a form that has a dropdown list of selections but many people forget choose the reasons. How can I make these required fields that HAVE to be filled in in order to print. These are internal forms, nothing on the web. I just need to find a way to make sure that there is a way to stop someone from printing if these 2 fields are not chosen.

View 5 Replies View Related

Active Worksheet Switches To Page Break Preview After Printing?

Aug 7, 2013

I have a workbook with multiple sheets where the view for each sheet is the Normal view.

If I print the entire workbook, the active sheet changes to the Page Break Preview view after the printing finishes.

I have to then reset the view back to Normal.

I don't know why the active worksheet is changing. I don't want to annoy the people who will use this workbook by making them change back to normal view after each time they print.

View 3 Replies View Related

Disable Paste Function (Including Drag And Drop) On Excel Worksheet

Jun 27, 2014

How can I disable the paste function on an Excel worksheet, including drag and drop?

Preferably I still want to retain the ability to copy.

View 1 Replies View Related

Printing Multiple Workbooks With Printing Preference As Landscape

Jan 15, 2012

I would like to know if there is a way to print several different workbooks at once but keeping my printing format which I would like to be Landscape and Fit to one page. Reason is simple as I work in a office where staff is handed in several jobs to do everyday. They finish the jobs and log all the info on the database. I log on to database and put all their daily diaries and because it is all over the place I have to go in each file and set printing preferences which takes an hour in the morning and hour in the evening. I could do with some sort of automation where all diaries are automatically printed in Landscape and Fit on one page.

View 2 Replies View Related

Printing / Not Printing Ranges Based On Cell Contents

Apr 11, 2008

I have a report that is generated from a manufacturing process that looks like the example below. the report is 40 pages long when all the data is printed. i am looking for a way to only print this range if a dimension is "out of tolerance". if the dimension is within tolerance, there is always the "garbage" text of plus and minus. if every row is "within tolerance" in the range the cells in the OutTol column would all contain the "garbage" text but it will not always be identical. so, in summary, actual OutTol values = print and all "garbage" = not printed.

NomActDevLoTolUpTolOutTol
Y-0.956-0.9480.008-0.0030.0030.005
Z-1.413-1.4130.000-0.0030.003---*|++++
DIA0.4220.4240.002-0.0030.006----|+*++
POS0.0160.0110.005

View 9 Replies View Related

Encourage Enabling Of Macros: Disable Macros When Opening Then The Worksheet Menu Bar And Other Command Bars Are Still Available

Aug 26, 2009

I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.

View 6 Replies View Related

Updatelink;' Remove Or Disable The Message On Update To Other Worksheet " To Update All Linked Click Yes"

Apr 18, 2007

I have been trying to remove or disable the message on update to other worksheet " To update all linked click yes......" I have try the following unsuccessfully

Sub auto_open()
Application.AskToUpdateLinks = False
End Sub

On the menu bar choose Edit ---> Links Can not choose manual, as the option is grey out (disable) I would prefer a vba solution, but I am open to anything to get rid of this message

View 2 Replies View Related

How To Disable #N/A

Jul 23, 2007

I have this following codes on cell G6

=VLOOKUP(G5,'P1'!K133:L135,2)

i want it to show an empty cell instead of #N/A if it returns 0 value...

View 9 Replies View Related

Disable Save As PDF Or XPS

Apr 16, 2013

Is there a way to disable 'Save as PDF or XPS' with the macro? I have tried disabling 'Save as' with the below VBA code but it does not disable 'Save as PDF or XPS'.

VB:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "Save As is disabled", vbInformation
Cancel = True
End If
End Sub

Also I have a macro which saves the excel report in a PDF format with 'Save as PDF or XPS' utility. I would like to enable 'Save as PDF or XPS' when this macro is started and again disable 'Save as PDF or XPS' when this macro stops.

View 1 Replies View Related

Disable A Button

Feb 1, 2010

I have a button on excel form. I need to disable it once user has clicked on it.

I couldnt find name of it on the form anywhere or how to refer it to in the macro.

View 9 Replies View Related

Disable Row Deletion

Mar 13, 2009

Excel 2003 - VBA - How do you detect when a row has been deleted in VBA? Better yet, how do you detect when a row is about to be deleted? I also would like to know the row number. I do not see an event handler that will inform me of the "Delete" event.

View 2 Replies View Related

Disable Macro Once Run

May 26, 2009

Is it possible to disable macro until next day once clicked to run

View 2 Replies View Related

Disable Cut And Drag Only Using VBA?

Jan 5, 2013

I need to disable cut and drag only in a workbook. The idea is to avoid formula reference errors when unlocked cells are cut and pasted or dragged. I can find many macros online but none that do only these two things.

View 2 Replies View Related

Always Disable Zero Values?

May 27, 2013

I am looking for a way that I can ensure that Zero Values are never shown, either when you open a new workbook or open a new window. Preferable, one which I can install for any user who needs this. (such as via Book.XLA I think) but AutoExec is fine as long as it is alwys loaded.

View 1 Replies View Related

How To Disable Read Only

Jul 10, 2013

I've got an excel sheet from a guy at work who decided to lock the entire document down so I can't do anything with it. Virtually all the ribbon options are greyed out, there isn't anything locking it in the code, I've tried checking the save as "read-only" option and it's not there. How I can actually save this is editable? I've looked in windows explorer and it's not read-only in there either. I tried save-as and even tried making it an XLS instead of an XLSM and it still won't let me edit it

View 1 Replies View Related

Disable ClearContents

Nov 30, 2006

I found this great code on this forum to disable copy/paste.

I would like to also disable ClearContents..

I can gather from the code that I just need to add a line similar to
EnableControl 755, False ' pastespecial

but change the # for the clearcontents command. But How can I find that number?

Sub DisableCopyCutAndPaste()
EnableControl 21, False ' cut
EnableControl 19, False ' copy
EnableControl 22, False ' paste
EnableControl 755, False ' pastespecial
Application.OnKey "^c", ""
Application.OnKey "^v", ""
Application.OnKey "+{DEL}", ""
Application.OnKey "+{INSERT}", ""
Application.CellDragAndDrop = False
Application.OnDoubleClick = "Dummy"
CommandBars("ToolBar List").Enabled = False
End Sub

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved