How To Protect The Worsksheet Name From Modification

Oct 8, 2008

I have an Excel template with 10 Worksheet(tabs). 8 of the sheets have predefined charts built based on the data in first 2 sheets. Through a web application user downloads data on the first 2 sheets. A macro is then executed (at the end of the download) to Update (through Macro) the charts in the remaining sheets and the sheets are password protected. The idea here is that user can generate predefined charts from the downloaded data but cannot modify any information. In addition to that user need an ability to add additional sheets to generate custom reports/charts.

So my requirement is to protect the 10 predefined sheets from modification including the modification of sheet name/deletion of sheet but allow user to add additional sheets. Protecting the workbook does not allow user to add additional sheets. Protecting individual sheets doesn't prevent user from renaming the sheet names.

View 9 Replies


ADVERTISEMENT

Protecting From Modification

May 18, 2009

I would like to protect the worksheet from modification by other users except column A ( suppose A1: A15).

I have been doing this by removing Locked on format cell and then Protect Sheet on Review tab.

Is it the right way or there are other more reliable way?

View 2 Replies View Related

SumProduct Modification

Feb 10, 2010

I have the following forumla: =SUMPRODUCT(($C$13:$F$74>0)*1)

I need this formula to compute only if B13:B74=A4. I am not too sure how to add this in.

View 2 Replies View Related

Addin Modification

Jan 18, 2007

I did modify some codes inside my addin, then did save the modified addin file by pressing the save icon from the VBA window..........but i found that the addin file was saved without the modification made to it. so i lost all modification did to the file. i donot know what i did wrong ?

View 2 Replies View Related

Right Click Menu Modification

Mar 21, 2007

I have been modifying the options available on my right click menu, getting rid of about half of what was there and adding items I use quite often like Paste Values, Paste Formats, Paste Formulas, Sort..., AutoSum, and Format as Percent, as well as adding group dividers. I have it just the way I want it, but I have one issue. If the clipboard is empty, all of the paste buttons are disabled on the Standard toolbar and in the Edit menu as are the Paste and Paste Special... items on the right click menu, but the new paste items I added to my right click menu are still enabled. If I click on one, I get a "PasteSpecial method of Range class failed" error because I have no range selected. I got around this by adding On Error Resume Next to the macros of my added paste functions - not elegant, but functional. Is there a way to have those items appear grayed out and disabled on my right click menu when the clipboard is empty as opposed to my current workaround?

View 9 Replies View Related

Search Database - Modification

May 29, 2009

Search Excel Database - Modification ...

View 9 Replies View Related

Password Protect Columns - Hide And Protect Ability To Unhide

Jan 17, 2013

Some sensitive data is held on worksheets that are used by people that do not have access to see the data.

It would be most convenient to keep the data in these worksheets but hide it from view of the users.

Is there a way to password protect a users ability to unhide a column?

View 2 Replies View Related

Slight Modification To Formatting Subroutine

Nov 7, 2013

I have a small sub routine below I would like to make a slight modification to. The routine currently references formatting relative to the Offset statement in bold below. Instead, I would like the formatting to come from a cell address listed in a cell just to the left of the cursor when the statement is encountered.

View 2 Replies View Related

Conditional Format Formula Modification

Jun 17, 2009

I'm using this formula in a Conditional Format rule.

=CELL("row")=ROW()

Can anyone help me modify it, so that only the active cell is formatted instead of the entire row?

View 9 Replies View Related

Modification Of Code/module At Runtime

Mar 7, 2007

way to save user-settings at runtime, preferably in the same or another module. For example: how can I save a bundle of variables such that the next time excel is started and the workbook is opened, the user can continue to work with his personal settings?

Background:
Using the macro, I am writing on atm, a user will be able to adjust the macro according to his input-samples. Here the columns and rows of an input can be varied to fit the macros requirements. It would be great if those settings could be stored, irrespectively of where the file currently resides. That is, best it would be, if the source-code itself could be changed ... maybe by adding another module?

View 3 Replies View Related

VBA Code Modification For Outlook Email Setup?

Aug 7, 2014

i was able to setup a email code, which will automatically extract the unique row reference data and sends the email. However, i am struggling to add couple of things, i searched most of the web portals .. wasn't lucky.

1. while email drafting i need to use the data from Column B onwards

2. i need to insert the default email signature during email draft ...

View 3 Replies View Related

Modification Of Macro To Clear Not Delete Page

Feb 26, 2009

I have a macro that I found on the net for copying a filtered selection and copying to a new sheet. I would like to alter it slightly so that it just clears the sheet called 'Interval tasks' instead of deleting it and creating a new one.

View 8 Replies View Related

Insert Copied Cells Modification (Macro)

Jan 26, 2014

I don't know if a macro is necessary, but the built in Insert -> Insert copied cells -> Shift cells down function can't accomplish what I require.

I've pasted in two example tables for what I'd like to do. For the first table, the data in column C is a name and the cells from columns D-Z, rows 7-10 is what I want to copy and paste from row 12, column D; row 13, column D; etc, etc. However, I want the full rows below the name in column C to move down when I paste from column D. Using the Insert function on the Insert blade only gives me the data in columns D-Z moving down.

The second pasted table gives an example of how I want it to look.

A
B
C
D
E
F
G
H
I

[code].....

View 4 Replies View Related

VLOOKUP Modification: Modify The Lookup Array Key

May 12, 2006

it's possible to set a "key" for a vlookup so that one of the parameters of that key can be any value? For example if the data set key used in the lookup contains a concatenation of 4 parameters (a_b_c_d), is there anyway to modify the lookup array key so that the "c" parameter can be anything, ie. something like a_b_*_d ?

View 3 Replies View Related

Data Validation Autocomplete Via Combobox Modification

Jun 7, 2007

I'm using a script that when you double click on a cell containing Data Validation > List it changes to a combo box that has an autocomplete/increased columns view...It's working great, however there are two small modifications I would love to do and am not having much success with. Currently, you double click the cell w/the Data Validation > List in it, it then changes to a combo box and you can auto complete using the keyboard or select the dropdown and choose from an increased list. However, I would like to be able to simply single click on the cell, have it change to the combo box and auto expand the list if possible.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Dim str As String
Dim cboTemp As OLEObject
Dim ws As Worksheet
Dim wsList As Worksheet
Set ws = ActiveSheet
Set wsList = Sheets("Rep Assist Report")
Cancel = True
Set cboTemp = ws.OLEObjects("RepName1")
On Error Resume Next
With cboTemp
.ListFillRange = ""
.LinkedCell = ""
.Visible = False
End With
On Error Goto errHandler
If Target.Validation.Type = 3 Then.....................

View 6 Replies View Related

Excel 2007 :: How To Add Date Of Last Modification Of File To Printed Pages

Mar 27, 2012

We are using Excel 2007.

I wanted to add the date of the last modification of the file to the printed pages, so I googled how to do it and found a useful answer on this from from 10 years ago. It said to press ALT+F11, then on the left side go under VBAProject, there go to ThisWorkbook and there paste the next code:

Code:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
For Each wk In Worksheets
With ActiveSheet.PageSetup
.LeftHeader = "Last Modified on " & ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time")
.CenterHeader = ""

[Code]....

Then I saved it and closed. Like I said, it worked perfectly.

The problem is that when I open the file after closing it, it does not appear, and I have to paste the code again every time I open it. Not only is this not comfortable, it also counts as a modification, so even if I haven't changed the work sheets themselves, just wanted to open and print it, it shows today's date.

My question is, who to I save it permanently so it will remain always after the first time I created it?

While we're at it, if there's a way for that code to appear on every NEW Excel file I create automatically

View 5 Replies View Related

Save File In Respective Month Folder As Per Current Year Vba Modification

Apr 3, 2014

In sub which will convert file to PDF and save it to assigned folder and then attach it to email in outlook. All works fine.

However is is possible to modify the code to save fole to respective month folder ( as per current date and year)?

e.g. I have created folder Named 'Trial' in C drive . This has sub folders 2014, 2015, 2016, 2017, 2018 Each year folder will have sub-sub folders month wise like This has sub folders as Jan , Feb , Mar , Apr .... till Dec Now e.g. if date when the pdf was created is 23/4/14 then it is saved in C:Trials2014Apr automatically. Currently every year I keep creating new folders etc... bit primitive though.

View 2 Replies View Related

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

Jan 12, 2007

I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub

View 3 Replies View Related

Merits Of VBA Protect Vs Non-Protect

Jul 26, 2006

I would like to protect the intellectual property of an application and have read differing opinions of the merits of protecting VBA code. What are the opinions of the experts on this forum? Are the password breaker programs so advanced that protecting code is a waste of time and only a hinderance to debugging and troubleshooting?

I am using MS Excel 2003 (11.5612) on XP.

I apologize if this topic has already been covered on this forum. I searched but did not find exactly what I was looking for. I am happy to review an old post if one exists.

View 7 Replies View Related

Data Validation With Data Modification?

Dec 18, 2013

Getting the data changes to reflect another tab.

In my case I have my data's on FW Group IP (tab) and FW Service Group (tab) and there is another tab called FW Rule Base (tab) and need any changes on the FW Group IP (tab) Row B to reflect on FW Rule Base (tab) row E. However I am also running Data Validation so that the FW Rule Base (tab) row E can have the drop down selection from FW Group IP (tab).

View 1 Replies View Related

How To Protect Sheet

Jul 10, 2014

I make excel file that contains certain formulas and graphs. Now I wonder is that a way for protect that file so it can be used only on specific cumputer, so if someone copy that file and paste it on their computer file will not work properly

View 1 Replies View Related

Protect The Range

Apr 5, 2007

i have a sheet that i write the date in Column D ,

A B c D
code name amount date
1 123 nasser 12.333 01-04-2007
2 123 nasser 122.333 02-04-2007
3 123 nasser 122.333 03-04-2007
4 123 nasser 122.333 04-04-2007
5 123 nasser 122.333 05-04-2007

what i try to do is to protect the range from A1 to D4 , which means to not edit any data in the day that before today , and to do it automaticaly every time i open the sheet
how to make that micro

View 13 Replies View Related

Protect An Addin

Nov 18, 2008

I am trying to protect an addin I have. I can protect the shared woorkbook, but when I save it as an addin the code is visible to the addin.

View 2 Replies View Related

Protect Call

Dec 8, 2008

I can protect my all sheet in excel but How to protect single cell or column, row? Is there any code for protect.

View 14 Replies View Related

Protect Workbook

Jan 19, 2009

Is there a button to protect a workbook in the same way that you can protect sheets? For example, I don't want a user to be able to touch any locked cells and there's multiple worksheets in this workbook. Do I have to go to each worksheet and protect them or is there a button to protect all worksheets at once?

View 3 Replies View Related

Protect The VBA Of Workbook

Mar 27, 2009

I have created an Excel workbook and protected the sheet. However, it still allows me go into the VBA section (Alt+F11) and edit away to their heart's content.

How can I protect my spreadsheet, as well as the VBA associated with it?

View 4 Replies View Related

Protect A Worksheet From Changes

Apr 24, 2009

how to protect a worksheet from changes so that I am still able to change one cell on the worksheet but not any other cells.

View 2 Replies View Related

Protect By PC Serial

Dec 5, 2007

is there a VBA that can protect the workbook by the computer serial Number .. so it won't work on another pc than this?

View 14 Replies View Related

Protect Sheet

Jan 21, 2010

My user form has a line of code that protects the sheets and does not allow any changes and selection of cells. It worked great on my personla computer.

Running the file on another computer the code does not protect the sheet. The strange thing is that if I go the Tools>Protection> the options is set to Unprotect. That measn that the code actually has protected the sheet but I am still able to make chages. If I manually unprotect and again protect the sheet, it is protected till the time close the file and open it again.

View 11 Replies View Related

Protect Buttons ...

Jan 24, 2010

Dear sirs,with best regards,i have in attached example file some cells i have protected them by ( tools-protect ) which is the general way for protection,for special purpose i ask you kindly to help me by:

creating a buttons with macros to protect and unprotect the ( cells,columns,rows,and all the sheet) that i need to protect them, when i want to (protect or unprotect) i have to click these buttons.

View 6 Replies View Related







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