Lock Saved Worksheet

May 28, 2009

I have code written to auto save the active worksheet when a button on my user form is pressed. What I would like to know is if there is a way to lock the worksheet when the button that triggers the save event is pressed behind the scenes so the end user has a more difficult time editing the sheet. I know they can just resave the document and the protection will be gone, but for minimizing user manipulation.

View 2 Replies


ADVERTISEMENT

VBA To Locate Different Worksheet To Last Saved?

Jan 28, 2014

I have the below formula that pastes data into the worksheet entered in the " " it works great but only when the workbook was last saved on that sheet, how can it locate that worksheet sheet even if the the workbook was last saved and another worksheet. if the workbook was saved on a different sheet name the vba doesn't finish

[Code].....

View 4 Replies View Related

Non-Changed Worksheet Asking To Be Saved

Jun 23, 2009

I chose to place this in programming, as all the functions for this workbook are either macros or Internet Links. Nothing is ever changed on the worksheet.

I have a workbook that is fully protected with passwords both for the workbook and the worksheet. When I set up the protection, no check boxes are checked.

I have macros and internet links on the worksheet that can be selected, but none of them affect the worksheet.

As a matter of fact, I can open the workbook and close it with only "Application.Quit" in a macro and a message box comes up asking if I want to save the changes or not. If I close it with the upper right corner RED X, it still asks the question.

I have no "On Open Macros" or Links of any kind.

I have other workbooks that this does not happen on.

View 10 Replies View Related

Tip To Show 'last Saved' Date On Worksheet

Sep 24, 2008

how I can have the latest date a file was saved showing on the worksheet? For example, I open a worksheet that was last saved on Sept 22nd, and after updating it today, I save it and want the date to show today's date?

I'm pretty sure I've seen it in some files in my working life, so would appreciate advice on this!

View 9 Replies View Related

Paste Worksheet To Exisiting Saved Workbook

Jan 8, 2007

I have one workbook named "Data Master" with numerous worksheets... all sheets are named with the following 6 digit format, eg. 005001, 005024, 005133, 005456, 005763, etc.

I have another directory with files each beginning with the particular 6 digit cost centre number.

I was hoping to have a macro that will... for each worksheet in "Data Master" check a specified directory containing the cost centre files, for the file beginning with the relevant worksheet's 6 digit cost centre number... and simply paste a copy of the worksheet in "Data Master" to the end of the existing sheets in the cost centre file.

View 9 Replies View Related

Doesn't Work If The Worksheet Hasn't Been Saved Yet

Jun 4, 2007

I'm trying to simplify a formula that I'm using in a spreadsheet that's being used mostly in Excel 2000.

2 reasons I'm doing this:

1) It doesn't work if the worksheet hasn't been saved yet.
2) It's ugly

=DATE(YEAR(DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,3) & " 20" & MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+5,2))),MONTH(DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,3) & " 20" & MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+5,2)))+1,0)

The formula returns the last day of the month of the name of the sheet. For example, if the sheet is names "Mar 07", it returns 3/31/07. (yeah, when the 2100 issue becomes a big deal, I'm not going to be ready but I have 92 years to think about it)

Even if I can't make it prettier, does anyone have a way to get the sheet name into a formula without VBA Code in a file that hasn't been saved.

View 9 Replies View Related

Entering Formula- Data Imported From Access And Saved As A Worksheet

Dec 7, 2007

I have a workbook with just one worksheet. It's just a list of data imported from Access and saved as a worksheet. When I try to enter a formula ie '=4+4' it goes in as text and will not calculate. I have tried various formatting to no avail. I added a second worksheet to see what happens and this works fine. (XP home, Excel 2003).

View 12 Replies View Related

Lock A Worksheet Tab So It Is Always Visible

Oct 3, 2008

I need to lock a worksheet tab (Main menu) in place so that it is always visible. There are multiple tabs that are all linked to the main menu by hyperlink. When work is finished in a worksheet I want the main menu tab to be visible and usable rather than using the scroll functions to get back to the main menu.

View 9 Replies View Related

Lock External Worksheet References

Aug 3, 2006

I have an excel workbook we use for quoting jobs. All our pricing references are in another workbook on our network. I have reference in the 'quoting' workbook that refer to the 'pricing' workbook.

The trouble is, when some users open the 'quoting' workbook, and have another Excel file open, some references to the 'pricing' workbook change to the other file they have open.

I suppose there is some sort of replicable condition that is happening, but I can't figure out what is going on or why.

So my question is: Can I ' lock' an in-cell reference to an external workbook so that it NEVER changes?

I tried hand entering the reference (network location+workbookname+sheetname) into a cell and then referencing that cell, but I couldn't get that to work.

View 9 Replies View Related

Budget Worksheet - Lock Cells With Formulas

Jul 24, 2014

So I am trying to create a budget worksheet for past and future expenses, basically an excel checkbook with running balance

In Column A I have my debits/credits

In Column B I have my running balance so that there is a current total next to each of the debit/credits in column A, it is formulated as follows, it adds the cells directly above it to the cell directly to the left of it (i.e. Cell B10 = B9+A10, which was dragged and iterated to many cells below)

I wan to be able to drag in drop cells in the A column (Just moving them up and down different cells in the A column) with out it changing formulas in the B column.

I tried the $ trick so that for example B10 = B9+$A$10 but if I moved cell A9 to say A10, I get a reference error in cell B10 (why is it doing this when B10 is locked with $)

I then tried going to format and locking the B column and not the A column and then protected the document but I still get the same REF error.

I know I can copy and paste with out effecting it but this is tedious, the whole reason I did this was so that I can move around bills EASILY and play around with what get paid when. There has to be a way to do this, but I'm probably searching with the wrong keywords.

View 1 Replies View Related

Excel 2007 :: How To Lock Author Of The Worksheet

Sep 13, 2009

It is possible to lock the Author of the Worksheet in File --> Properties --> Summary Tab..?

I am using Excel 2003 & 2007..

View 8 Replies View Related

Lock And Protect Worksheet After A Date In Cell

Feb 1, 2013

I have a worksheet that is protected with data entry cells unlocked.

1. Unprotect worksheet
2. Lock all cells in the worksheet and then protect.
3. After a date in a cell in the worksheet.

I'm a newbie to vba and at least know vba is the only way. And this need to be automated.

View 1 Replies View Related

Use VBA To Unlock/lock A Worksheet For Data Entry?

Oct 16, 2009

I have a worksheet that, unless a form for data entry is activated, should be read-only for columns 'A' thru 'M' and 'O' with column 'N' left editable.

The form is activated by a button with a macro assigned to enter the data in the above columns when the form is closed. This has been compiled and works nicely with the sheet unlocked, however, as i need certain columns to be read-only unless the form is activated, i'm stuck with leaving the whole sheet unlocked for editing with or without the form being activated.

Is there any way a VBA code could be used to unlock the worksheet columns that are read-only when the form is activated, and then lock them once the form data is entered to the worksheet and the form closed?

View 9 Replies View Related

Restrain/Lock Image Into Position On Worksheet

Aug 18, 2006

Is it possible by using Visual Basic coding to position an image on a worksheet so that no matter what the screensize is it will always appear in the center of the screen, a corner or a side?

View 9 Replies View Related

Excel 2007 :: How To Lock Individual Cells In A Worksheet

Jul 23, 2014

How to Lock Individual Cells in a Worksheet excel 2007 .... i.e.

A2:A8

I want this selected area locked with password.

View 1 Replies View Related

Lock Sheets With Formulas And Lock Sheets With Values

Jul 2, 2009

do you know if there is vba code to lock formulas so someone sees but does not touch and the same for values see but cant change??

my sheets with formulas are SUMMARY and Sheet2

sheet with value is TABLE

View 9 Replies View Related

Changes Could Not Be Saved

Apr 30, 2006

I am getting the following error message while trying to save an excel file into server location.

Your changes could not be saved to [filename], but were saved to a temporary document named [number]. Close the existing document, then open the temporary document and save it under a new name.

I am using:
OS: Windows XP Professional with Service Pack 2.
Office 2000
Server: Windows 2003 with Service Pack 1.

View 4 Replies View Related

Load Saved Csv In The New Sheet?

Aug 30, 2013

I created the csv file from excel sheet. Now I have created a copy of that excel sheet in a new sheet, and I am trying to load that saved csv in the new sheet. But when I do that I see some cells formatting mismatch (can be seen in attached picture) though I clicked on preserve cell formatting at the time of import.

View 2 Replies View Related

Saved Files Read Only.?

Jan 8, 2009

I took two weeks perfecting an Excel file and was writing them to disc just now to transport and use on other machines. I opened the file to add instructions and the files are now read only? Propteries show read only on the written files but not on the originals???

View 4 Replies View Related

Execute When Workbook Saved

Oct 15, 2009

I would like to execute a sub when the workbook is saved, what is the procedure for this.

View 3 Replies View Related

File.Saved Changing

Nov 30, 2009

I have a file that keeps setting it's "Saved" property to False when I change something in another file. I cannot find any external links in the file.
The file used to be "Personal.xls", but I renamed it.

View 4 Replies View Related

Date Format Is Not Saved In CSV

May 5, 2014

I have an excel file in which the date format for a column was in the following format -: 3/14/01 Since I wanted the column to display in 'mm/dd/yyyy' format, I changed the type to -: 03/14/01 and the sheet was saved. I then for a specific purpose converted the xls file to csv and noticed that the date formatting I did is not getting saved. That is, every time I open the csv the date format changes back to 3/14/01.

how to retain the date format in excel? I need to use the date format in mm/dd/yyyy only for the application I'm using.

View 2 Replies View Related

Last Date Saved Code

Nov 29, 2006

does anyone have a simnple code that when entered in a cell only returns the last date the file was saved? better yet, could it somehow be specific based on a modification to a specific worksheet modified?

example: i have 8 worksheets. how can i show when one worksheet is updated, say November 27th 2006, and another worksheet on November 28th 2006?

View 9 Replies View Related

Last Date Saved Formula

Dec 20, 2006

Is there a formula that will get the date & time the workbook was last saved? I am using an earlier posted macro now but would like for the information to be visible constantly in a certain cell. Possible?
Macro used:
Sub WhenSaved()
MsgBox "This file was last saved on " & Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), "mmmm d, yyyy") & ".", 64, "Date of most recent save:"
End Sub

View 9 Replies View Related

VBA Macro To Tell Who Last Saved A File

Oct 10, 2002

Macro (saved on the workbook not in the Personal macro file) which should give the following info (lets say on sheet 1, starting A1, A2) who last saved that file and the date.

View 9 Replies View Related

How To Get Last Saved Data Into Sheet

Aug 30, 2007

I have an excel sheet which is shared, i need to get the date and time when the sheet is last saved in one Particular cell.

Example: In A1 = 16/082007 09.00am (in whatever format)

View 9 Replies View Related

File Cannot Be Saved In This Format

Jun 16, 2008

I have a file with code attached and when I try to save it I am told that the file cannot be saved in this format and that I must unprotect the code before saving.

I have no OnEvent macros in the code.

Does anyone have a solution for this problem. The code must be protected, non-protection is not an option.

View 9 Replies View Related

Document Not Saved 1004

May 15, 2009

I have an xls file that has many sheets in.

One of the sheets is a sumamry sheet that get's dulpicated, values pasted, then (the single sheet) exported to a new file. Upon trying to save this file, I keep getting the run time 1004 error message and that my document cannot be saved.

I've struggled for days trying to find out the source to no avail.

What is more frustrating is that when I try to save it (after exiting the macro), it seems to work ok.

I do get the compatability error message (which I don't get on the 'original/parent' workbook) there is a not about format errors, though I'm not sure that's the source of the problem.

View 9 Replies View Related

Time Passed Since Last Saved

Mar 8, 2007

Private Sub Workbook_Activate()
Dim user As String
If Worksheets("Setup"). Range("D6").Value = "" Then
user$ = InputBox("Hello. Please enter your name to inialize the program", "Enter Name")
Worksheets("Setup").Range("D6").Value = user
MsgBox ("Welcome " & user & ". Press 'OK' to continue on to the Main Menu.")
Else
user$ = Worksheets("Setup").Range("D6").Value
MsgBox ("Welcome back " & user & ". Press 'OK' to continue on to the Main Menu.")
End If
Exit Sub

but i would like to expand the "welcome back" msgbox to also display "the last time you were was was (eg: 2 days/3 hrs/14 min) ago" - which i presume would be calculated from the last save.

View 5 Replies View Related

Changes Aren't Saved While VBE Is Protected

Sep 2, 2007

I have a WorkBook of 13 sheets

it has 2 Modules:

one unraveling protection from cells protected and restore it to all Sheets in a single step

And the second controls printing process to make it only for rows that conaining date in the predetermined columns

that latter is to break the protection, execute printing and re protection again without user intervention

The strange thing is : after protecting these modules from being viewd by users as it contains THE PASSWORDS .....

View 9 Replies View Related







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