Disable Users From Printing The Sheet

Jan 19, 2009

I tried to disable users from printing the sheet
with this

View 6 Replies


How To Disable Cut In A Specific Sheet For Users

Aug 8, 2013

how can i disable "Cut" in a specific sheet for users?

View 3 Replies View Related

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 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

Protect Or Unprotect Sheet By Various Users?

Jun 22, 2014

Is there is any way we can protect sheet in such a way that; if user - Mr. A inputs his password he can only go and is able to input his data in sheet 1.

I've a file which have multiple sheets say about 80 tabs are present. My colleague only works on one of the tab (sheet) enters data, that file is placed on our general sharing folder I want to know if it is possible that I can assign protection in such a way that when she enters her password she is able to input data only on the sheet in which she works and cannot roam around to other sheets?

Or is it possible that on first sheet there is username or password can appear? And if the data inputting person opens that file and enter her password option appear which can take her to that particular sheet? And if a guest open that file he/she can only view particular sheets which contain reports?

View 1 Replies View Related

Protected Sheet Not Behaving The Same For All Users?

Mar 22, 2012

One of our password-protected shared workbooks is acting oddly, but only for one user. The protection is supposed to allow users to expand and collapse grouped columns using the "+" and "-" symbols on the sheet, and for most users it is; but one user is getting an error message that she can't perform that operation on a protected sheet. I've had her close and reopen the file and we have confirmed that she has the same version of Excel as the users who aren't having the issue (Excel 2007). This is a shared file on a server, not a local copy on her computer.

View 2 Replies View Related

How To Allow Users To Copy And Paste In Protected Sheet

Aug 13, 2014

Enabling users to copy and paste values in a protected sheet.

The sheet is protected because some of the columns are autopopulated based on formulas and I do not want someone to spoil the file.

Users are complaining that in many cases half of the information which they enter in one row have to be repeated in the nect 10 rows.

[Code] .....

is already in place to allow users to select and copy. How to enable them to paste in the same protected sheet?

View 2 Replies View Related

Multiple Users Updating Same Sheet Simultaneously?

Jul 17, 2013

I have a workbook with a list of drawing numbers (with customer, date, author etc.). New drawing numbers and their associated row of information are entered onto the sheet...

..HOWEVER, multiple users can be at least viewing and potentially entering information simultaneously.

I have written code where multiple people can view the same read only file, but not edit it and it be updated.

It seems quite unlikely, but is there anyway of 'live' updating a workbook whilst multiple people are viewing it? Or at least notifying other users when the sheet has been updated?

View 2 Replies View Related

Printing A Sheet For Every Day

Oct 13, 2009

I have this attached sheet that i need to print one for every day for the next 12 months.

The problem is i can find a way of doing this and getting the cells in red in row 6 to change to the next date.

View 8 Replies View Related

Disable All Cells Not In Use On A Sheet?

Oct 8, 2013

I have several cells in a column for the user to input data, and then a "submit" button. It is a very basic sheet to take user input and store it on another sheet and then manipulate(pivot) and display(graphs) on respective sheets.

Is it possible to remove gridlines and disable all cells on the input sheet except for those that take input, currently validation cells. The main reason is when the user hits tab or lets say enter it moves to the next field for data entry as opposed to through the two empty cells between that are there for spacing. Also to disable them from editing the text that poses the questions(labels): "

View 2 Replies View Related

Disable CUT And PASTE In ONLY One Sheet?

Feb 17, 2012

I have seen all the past questions and answers on this subject but mine has a little twist to it.

I only want 1 sheet in 12 to disable CUTTING AND PASTING but I want the user to be able to COPY and PASTE VALUES ONLY in this sheet.

Is there a macro for this?

View 3 Replies View Related

Protect Sheet Allowing Users To Format Rows/Edit Objects?

Nov 16, 2009

I want my macro to protect my sheet again after it is done to allow editing objects and formatting rows. I am really stuck and have come up with the below, but it isn't working.

View 5 Replies View Related

Printing Filtered Sheet?

Apr 16, 2014

I have a spreadsheet that has a macro that hides all columns that have 0 in a sum cell. I want to automate printing of the result, there will always be 35 rows but the number of columns will vary, could be 10 could be 30. The cells are hidden not deleted. How can I set up print code to print all visable cells? I need then all to be printed on the one page so scaled to fit.

I tried to record a macro but as the column count varies I get lost....

View 5 Replies View Related

Specific Sheet Not Printing?

Jun 27, 2013

In this file sheet1 is not printing. But other sheets r ok. It show print preview. Also it take print command and printer also show that printing. But actually not printing. The printer not even taking paper for printing.

View 3 Replies View Related

Printing A Filter Sheet?

Mar 7, 2014

I have a spreadsheet that we filter to only show active actions. Looks good on the screen but when I try and print the sheet it doesn't print all the visible lines...

View 3 Replies View Related

Stopping Sheet From Printing?

Oct 4, 2011

how do i stop a sheet from being printed and add an error message/ dialogue box saying this sheet cannot be printed, view only etc etc. this to appear when they goto the print option in the menus.

View 5 Replies View Related

Printing Fileinformation On The Sheet

Jun 1, 2008

I have a file that needs to be dated when it is printed. Is there any way to make the following things to appear on the sheet/workbook:

- Printing date/time
- filename of the current file that is printed
- the date of latest time/date the file was edited
- the person who printed the file (based on the user profile that is logged in the system.

View 9 Replies View Related

Disable Sheet Tab Menu Selections

Dec 22, 2006

I want to disable the functions via right mouse click on a sheet tabs to workbook users.

As the programmer I may need to access these function on occasion.

My VBA is password protected to keep other users out.

View 9 Replies View Related

Disable Right Click When A Sheet Is Active

Jan 31, 2007

I need to display Excel Sheet in a Browser and I want to disable the Right Click and Menu of Excel(File, Edit).

So in the method Workbook_Open i coded following

Private Sub Workbook_Open()
Application. CommandBars("Worksheet Menu Bar").Enabled = False
Application.CommandBars(" Cell").Enabled = False
Application.CommandBars("Sheet").Enabled = False
Application.CommandBars("Ply").Enabled = False
Application.CommandBars("Row").Enabled = False
Application.CommandBars("Column").Enabled = False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Cell").Enabled = True
Application.CommandBars("Sheet").Enabled = True
Application.CommandBars("Ply").Enabled = True
Application.CommandBars("Row").Enabled = True
Application.CommandBars("Column").Enabled = True
End Sub

It works fine, but if I open Excel application before viewing this HTML page(which contains XLS) and then the option are also disabled in Stand alone Excel application. I want to disable option when for this Sheet which is opened.

View 2 Replies View Related

Excel 2010 :: Create A Sheet Which Captures The Worked Hours For Users In Various Cells?

Apr 1, 2014

I am trying to create a sheet which captures the Worked hrs for users in various cells. The SUMPRODUCT does not seem to be working for me .

Attached is the sample sheet which i would like to get the SUM using SUMPRODUCT.

Col D under Data Sheet has the names and these are repetitive. The Hrs / min in column E & F (Regular Hrs) & Additional Hrs / min under H & I.

I would like to have the Regular hrs + minutes to SUM up against each individual and displayed in consolidated under Col D (Regular hrs) & Col E (Additional Hrs).

I am using Excel 2010 and when i have used the same formulae in 2003 it worked. Not sure why it is not working in 2010.

View 2 Replies View Related

Printing Multiple Pages Per Sheet?

Jan 22, 2014

I'am trying to create a document which automatically prints the next page on the same sheet.

I have created a spread sheet which prints the first 5 rows in the top of every page, but I can't figure out how to make excel print two A4's on one A3 side-by-side.

View 2 Replies View Related

Printing Sheet From List Reference?

Mar 25, 2013

I am sure it is easy as I have done this before, but can't remember how or where I have put the code.I have a spreadsheet with multiple worksheets (The amount and names of sheets will keep changing). On a front sheet I have a dynamic validation list in cell "L9" that will always have the full list of spreadsheet names. The idea is that I will choose which spreadsheet to print from this list. Press a button and only that sheet will print.

View 4 Replies View Related

Printing Multiple Pages On One Sheet

Mar 28, 2007

I need to print 2 pages on one sheet. Page 1 on top, page 2 below. I can get this to work on Portrait, but I need it printed Landscaped.

View 9 Replies View Related

Missing Row When Printing A Splited Sheet

May 16, 2006

I have a sheet which contain an horizontal split (Option Windows/Split). I have selected the row 16 to split the sheet so that I can have a header when I scroll down. However, when I print this data sheet, the first row, at the top of the screen, is missing. In the preview and on the printed sheets, the first row is missing on the next printed pages. In the first page, all is ok, but not on the next ones. Does someone have an idea why Excel is behaving like that?

View 5 Replies View Related

When Protect The Sheet - Delete And Shift Up Disable

Aug 8, 2013

I have a sheet,i want the users unable to select any cells,but a column is free to select an change and enter the inputs. I want to delete and shift up zero cells on that free column,but this property is disable when i protect the sheet.

How I protect other cells from selection and change,and enable delete and shift up for the column that not protected.

For example: I have the attachment file,every column is protected except column "H". I want a macro to when I clear content of any cell in this column,every cells shift up and every non zero cell put from row 1 to... and after them zero cells put.

View 2 Replies View Related

Disable Copy / Paste Option For Particular Sheet?

Dec 8, 2013

I have workbook having 3 sheets out of them 1 sheet name "report". I want vba to disable copy /past option to sheet Report only with msg " copy not allowed" if key clt+c or copy option selected

View 1 Replies View Related

Activate Sheet And Disable Tabs On Open

Dec 6, 2008

I am trying to create an event macro that would deactivate column and row headers when the workbook is launched and activate a sheet. i am not managing to do this,

View 2 Replies View Related

Enable/Disable Command Buttons From A Sheet?

Oct 14, 2009

How do I Enable/Disable Command Buttons from a Sheet?

I am using a Command Button in a Sheet to copy and paste the Data from one Sheet to another with the help of macro..

As I am not well-versed with VBA dont know all the syntaxes of VBA.
I need help for the command button..

First and Foremost, I double click a Command Button form the Control tool-box and paste it on the Sheet, I dont know how to get the name of this command button , I mean where do i get it?

Based on a condition like a value in a cell I want it to be Enabled and Disabled?

Any ideas...please I am not able to follow even after googling a lot as I dont know what's the name of the command button control I have used.

If the value entered in a particluar cell is more than the 1000 difference between two cells then the command button should be disbaled...

The Application part:
The command button is used to transfer the data in a cell lets say $I$4 to another sheet Cell J2,J3,J4 so on so forth..by incrementing the ROW number.

Now The balance gets depleted with every new Debit Entry and we need to disallow the user from entering such an amount which will reduce the balance more than The Minimum Account Balance of a bank...

View 14 Replies View Related

Disable External Links When Creating New Sheet?

Mar 7, 2012

I have VBA code that creates three reports based on fields a user chooses. When the user clicks the button to create the first report, links are built to the files which contain the fields they chose. There are approximately 15 files that need to be linked in every report.

When the links are built, referencing the external files, the system is extremely slow.

I have Application.ScreenUpdating = False and Application.Calculation = xlCalculationManual.

Despite these settings, the links pull in updated values.

Also, to create the last two files, I do a FIND/REPLACE to change the cells referenced in the links, causing it to choke.

would get the links in place without updating each one as it is created?

View 1 Replies View Related

Disable Sheet Charts And Cells Updates

Apr 25, 2007

I want create something (a macro), maybe ending in a button to activate or desactivate the update (relatively) of the charts and relative cells in one of various sheets i use!

If the button is turned off the sheet is quiet!

View 9 Replies View Related

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