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


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

VBA - Run Only For Specific Users?

Jun 3, 2014

I want to run an event for specific user. In this case, only John Doe should be able to run this command. It works fine if i put john doe in there and i get the MSGBOX since my windows log in is not John doe. But when I put my windows login there (and only I can run it), i dont get any msgbox or the rest of the command does not run..

View 10 Replies View Related

Prompt Users To Enter Information In Specific Range Of Cells Before Save

Mar 11, 2014

Is there a way to prompt users to enter information in a specific range of cells before they save?

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

Disable AutoComplete For Specific Cell

Jun 12, 2008

how to disable autocomplete for a specific cell. There is only one cell (A11) that I don't want to use auto complete but I want every other cell to be able to still autocomplete. I think it may have something to do with matchentry being set to 2, but I'm not sure how to do this.

I don't know what sintax I need to use. I've tried this line of code but it doesn't work

A11.MatchEntry = fmMatchEntryNone

View 8 Replies View Related

Disable Print If Specific Cells Are Empty

Jun 19, 2008

I am currently trying to keep the print feature disabled in excel untill any of three specific cells are filled out. So that any of the following possibilities would work:

A2 H2 P2
[x] [ ] [ ]
[ ] [x] [ ]
[ ] [ ] [x]
[x] [x] [ ]
[ ] [x] [x]
[x] [x] [x]

This is what I've got so far.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If IsEmpty(Range("A2,H2,P2")) Then
Cancel = True
End If
End Sub

This code works for A2 but I can't get it to work for H2 or P2. i.e. print will be enabled if A2 has content and disabled if all three cells are blank, but if A2 is empty and H2 has content print will remain disabled.

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

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

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

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

Option To Hide The Sheet When Disable Macros Is Clicked

Apr 29, 2009

Is there any option to deactivate the "Disable macros"

Or

When i open the userform it asks for enable and diable macros. If i click "Disable macros" then the users can manipulate the data inside the excel sheet. i need to avoid this problem.

So, is there any option that if i do "Disable macro" then the corresponding sheet for the which the Userform is linked should not be visible or hidden.

View 9 Replies View Related

Disable User Access To Master Sheet Through Doubleclicking Locked Linked Cell

Feb 23, 2010

I have a master spreadsheet that houses most of the information that remains in my control, and several other user spreadsheets that update cells from that master through links.

I am having some problems lately with users doubleclicking the locked linked cells in their workbooks, and excel then wanting to open and give the user access to my master spreadsheet. Is there a way to disable this feature? I would like it to not even acknowledge the action if that's even possible because it confuses them as to why they are getting a prompt to open another document.

View 5 Replies View Related

Allow Users To Print Hidden Sheet But Not Change Print Settings

Jul 2, 2009

I am having trouble disabling the "Preview" button when calling Application.Dialogs(xldialogprint) in XL2003. I have an xlSheetVeryHidden worksheet containing a form which is made visible programatically when the user wishes to print a copy (code below). I want the user to be able to have access to the functionality of the xlDialogPrint dialog (i.e. select desired print destination, number of copies, pages per sheet etc.) but I also want to prevent them modifying the page setup of the protected worksheet by initiating a preview from the print dialog.

Private Sub btnPrintReturnForm_Click()

wbkRUSC.Unprotect sysPass 'unprotect workbook to enable changes to sheet visibility
' (sysPass is project constant string containing password)

shtStaffForm.Visible = xlSheetVisible 'make staff form visible

shtCalc.Visible = xlSheetVeryHidden 'hide main calculator in case user gets smart and hits..............................

View 5 Replies View Related

That Takes From Manual Sheet The Number In Specific Column And Multiply It By The Percentage In Sheet

May 29, 2009

I'm trying to create a formula that takes from "Manual" Sheet the number from colume G2 and multiply it by the percentage in sheet "AllocationRule".

My formula currently is =Manual!$G$2*AllocationRule!$B5.

What needs to happen is that the total number in "Manual" needs to be distributed evenly in 4 rows by the percentages allocated in "AllocationRule".

Right now I can't copy my formula over to the sheet because the "AllocationRule" should stop at B5 and not go further and the G2 from "Manual" should not change for the percentage allocation but should change to the next row for the next month.

And then after I've done the calculation I want the LOB in "AllocationRule" to be displayed in the LOB in "H1913_H1914" but I'm not sure what formula to use.

View 7 Replies View Related

Entering Data Onto Main Sheet That Automatically Transfer To Specific Sheet?

Feb 9, 2014

I remember years ago that I made a couple formulas that on sheet one would transfer to another sheet when I enter in sheet one.

View 5 Replies View Related

Copy Cell From Specific Sheet & Paste To Active Sheet

Mar 31, 2008

I would like a macro that will go to a fixed sheet, copy the format, go back to the previous sheet and paste the format. My problems arise going back to the previously activated sheet rather than just a fixed sheet.

View 2 Replies View Related

Copy Specific Range From One Sheet And Paste To Next Available Row Of Different Sheet

Jan 20, 2009

I would appreciate if someone can help me figure out a macro that will copy range (A3:T112) from "Step 1" sheet to next available row in "Step 2" sheet.

View 8 Replies View Related







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