Free Microsoft Excel 2013 Quick Reference

Header & Footer make template for multiple users

I´m looking for a possibility to program a template for excel 2003 where the
file creator and the creation date automatically appear in the header and or

Is there any code to program this and how do i make it as a template on all
computers through the entire company?

Post your answer or comment

comments powered by Disqus
Love this site, always coming for more.

Question: Is it possible to have a password input box for multiple user, then when a user log ie: user1 will make user1 worksheet visible. and administrator will make all worksheet visible.

Let me know if you can help or where I can find more info.



I'm new to using macros in Excel and I've recently received help creating a macro to enable my worksheet to autosort by date upon opening the workbook, as well as automatically go to the most recent date listed. It works great for me, but it does not work for other users in my office. Is there something additional the macro needs to operate for multiple users?

Here's the code:

Private Sub Workbook_Open()
Dim DestinationRow As Integer

ActiveWorkbook.Worksheets("Events").Sort.SortFields.Add Key:=Range("A2:A4000") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Events").Sort
.SetRange Range("A2:D4000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
End With

DestinationRow = Worksheets(1).Range("Z1").Value
Worksheets(1).Range("A" & DestinationRow).Activate
End Sub

And here's the formula in cell Z1, if it helps:

Thanks in advance for your help!

I need some advice. You may have seen my other thread. I'm getting back into developing spreadsheets for work. I have never made one for multiple users, a shared one, that is.

It's basically a database of projects, each project being assigned to a particular salesperson, one row per project, but all together on the spreadsheet, so the boss can see all of the projects, total them, make sales forecasts, charts, etcetera.

I figure my spreadsheet will sit on one of the company servers, and each user will open it over the network connection. He'll add and update his projects and then exit from the spreadsheet. It is my understanding that only one user can make changes to a particular spreadsheet at one time. Maybe I am wrong. This would be a downside.

But if I am right I had the second idea of having the spreadsheet on the server, like in the first example, but having it set up so that when a user opens it up, the spreadsheet recognizes the user and gives them a copy of the worksheet, loaded with their projects only. They can edit their projects, add new projects, whatever, at their leisure, as it would only be a copy, and it would reside on their computer. When the spreadsheet is closed or a button such as "UPDATE" is hit, the main spreadsheet would sync his projects back in, with the new data.

I like the second idea better but I know it will be more programming-intensive but the users would like it better.

Any advice or suggestions??

I've created an Excel template with some VBA code for Excel 2007. I am distributing using the Inno Setup compiler.

If I install in:
C:Documents and SettingsUser NameApplication DataMicrosoftTemplates this works OK but not all users can create a new file from the template.

If I install in:
C:Documents and SettingsAll UsersApplication DataMicrosoftTemplates it doesn't work.

Can anyone tell me where I install the template for all users to be able to create a file from my Excel 2007 template?


Hi Everyone,

I am using an ADO Connection to connect to an access database from excel. The connection is used to retreive a tracking number from the database and then update it to show the tracking number has been used.
Am currently investigating seesion pooling to decrease the wireless network load. There are multiple users using this code over our wirless network.

Can pooling be implemented for multiple users with the same connection?

Code so far:

Dim adoCon As ADODB.Connection 
Sub OpenConnection() 
    Dim sCon As String 
     'Open connection
    sCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ 
    "Data Source=ALLANDatabasesTrackIDs.mdb" 
    Set adoCon = New ADODB.Connection 
    adoCon.Open sCon 
End Sub 
Sub CloseConnection() 
    Set adoCon = Nothing 
End Sub 
Sub TestConnection() 
    Debug.Print GetTrackNo 
End Sub 
Function GetTrackNo() 
    Dim adoRCS As ADODB.Recordset 
    Dim lTrack As Long 
    Dim i As Long 
     'Set New Recordset
    Set adoRCS = New ADODB.Recordset 
    With adoRCS 
         'Open Record Set
        .Open "SELECT * FROM Table1", adoCon, adOpenStatic, adLockOptimistic 
         'Get New Tracking No
        lTrack = .RecordCount + 1 
         'Add New Tracking
        .Fields("ID").Value = lTrack 
         'Update Tracking Databas
         'Close Record Set
    End With 
     'Set All Variables To Nothing And Close Connection
    Set adoRCS = Nothing 
    GetTrackNo = lTrack - 1 
End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The open and close connection subs are run on wrkbook open and close respectively.


I want to shar an Excel file for multiple user for entering data. anybody
has any idea?
any help would be appriciated.

Farhad Hodjat

i have one excel sheet and i made it shared for multiple users. i want when
any 2 or many users open it at the same time and start to type in it, the
first one who will type should block others to type in the same raw.
i mean for example, if user A opens the sheet and start to type in raw 20, i
want that this raw will appear in diferent color in the same time to any
other users and so on.
thx for your great support

Dear Experts,

Is it possible to use the userform when it is protected and shared.
I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [B]issue in the forum.I understood from the answers that it is not possible.

" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"

Please give me a solution.

" Being a moderator myself i should only be able to edit or modify the entries made by the users."

I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)

Also provide me an alterante solutions if any!!

Hi All

Can anyone help me? I have gone brain dead. What i am trying to achieve is a user security login feature that alows certain access to certian people.
At the moment the access levels assigned changes the colour of a cell (as i will add more code later). But what i am really stuck on is adapting it for multiple users, ie me (James) and Lara. I just cannot remeber the Vba to do it.

Heres the code so far:

Sub workbook_open()
UserName = InputBox("Please Enter Your Login ID", "Login In")
If UserName <> "Lara" Then GoTo Wrongname
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Exit Sub
MsgBox "You can only access this document as view only"
Selection.Interior.ColorIndex = 3
Exit Sub
End Sub

Any help will be much appriciated


My issue is:

What I want is I have a worsheet that stores the data basis which it generates reports. I would like to know that how to make that worksheet available for 20 users at the same time. All the users can access and save the data at the same time in the same worksheet. Is that can be done by simply sharing that worksheet or is there anything else that I need to do.

Pls help ..




I was looking to set up a username/password protected workbook which will lookup a username and validate against a password.
I want to add access levels based on the user name. I am trying to have different Start Pages be visible depending on the username. I have 4 Start Pages but many users.

For example; User "Ford", "Jackson" and "Horn" will only get access to Start Page 1 but
User "Smith" "Connors" and "Grean" will only have access to Start Page 2 and so forth for 4 different Start Pages

I will have about 3000 users so I have a worksheet titled "Users" with all user names in Column D, password in Column E and an access level in Column C. This column arrangement can be modified as needed.

I was going to use the system user name, but I do not have access to all user's system ID.

Thank You for any and all assistance.

Conditional Copy & Sum with 3 variables, one a cell reference

Payments are entered usually by date on the Payments sheet, based on those payments, I need to sum the code 3 payments on the Adj sheet by name and Qtr.

I original created a pivot table to do this, but I want the workbook (w/o data) to be a template for other users, and the users are not going to know how to do a pivot table report, and I would prefer the totals to update w/o updating the pivot table. I actually was just using the pivot table to supply the data to the sheet anyway, but I couldn’t setup/automate the pivot table with no data in the list/table on a blank template?

I want to copy/transfer just the data, similar to the results of the pivot table, based on the 3 criteria to another sheet.

Variable1 – Name (Unique records only, not known until after entered)
Variable 2 – Payment Code 3
Variable 3 – Quarters 1-4

I've attached a sample version of the two sheets, and my attempts.

Thanks in advance for any help, every time I have an idea on how to do this, I hit another dead end or another another area I lack knowledge in.


Can someone explain why the character & will not appear in the header/footer in Excel.

For example, I need to insert the company's name which is Morrison & Foerster, LLP in the header.

The result is only Morrison Foerster LLP.

The '&' will not appear.

Can anyone explain why and recommend a solution.

Thank you and best regards,

I making a template for multiple users to import data into for analysis. I want them to be able to delete and drag-and-drop data to get rid of any bogus values. However i need forumlas that reference those to NOT follow the values as there as moved.

As a simple example say you have two columns, column A is a set of random numbers, column B is the number from coumn A times 2. If take the bottom half of column A and drag it up one cell, overwriting a cell, now the cell in column B next to the overwritten cell has a #REF err and ever cell below that now references a Cell in column A from the previous row. I want a formula that references a static address and will not follow the cell if it is moved.

If I use named ranges rather than specific cells references it works for the above example, however for my actual form it does not. Even though the ranges and formulas stay the same I start getting incorrect values. If there is no other way to this I will try to figure why the named ranges do not work.

Locking the cells and protecting the sheet also does not work.

Attached is a great workbook created by Dave Hawley which allows multiple users with individual passwords.

Dave or anybody, some workbooks I have contain sheets that are updated by different people and I need to limit access to these sheets. Can you have it so that depending on which user signs in, they only have access to certain sheets and that the remaining stay hidden.

This would be great if it could be done.


Is there a way to copy header /footer information?

a. on multiple sheets in a workbook?
b. from one workbook to another.

I have to create monthly reports and only need to change the month, but the remainder of the text remains the same.

I am currently updating header/footer on a worksheet by worksheet basic


Hello Forum,

I have public computer in a lab that multiple users have access to. I need to share a custom toolbar so that whenever a new user logs into that computer and opens Excel 2003, they have the same toolbar. Specifically this is a macro tool that they need access to.

I've searched the forum but I haven't really seen anything. Please let me know if you have any ideas. Thanks.

Hi all,

I have a workbook that I would like multiple users to be able to access at the same time. Since my values are inserted through a form in the workbook I came up with the following solution...

The workbook was set to shared. The data entered is entered through a form. When the user have entered his/her data and clicks the OK button the following happens...
1. The workbook is saved (=all updates from other users are entered)
2. The values in the form are inserted into another sheet of the workbook.
3. The workbook is saved once again so the new values are committed.

This process takes about 15 seconds today, but I think my users are willing to accept this if the workbook isn't locked only to one user. I'm also counting on that the workbook doesn't become too big so that the saving process takes too long. Is this solution ok? Is there a better solution without having to add a real database?

I am creating a spreadsheet which needs to be edited by many different user.
What i would like it to do is that the user enters their password which unlocks certain cells for them to edit (different cells for each user), once finished the spreadsheet is relocked.

Is this possible , and if so can someone please guide me on how i would achieve this. My VB programming is not great, so any help with this would be greatly appreciated .

I want to insert the content (text) of a selected cell in a header/footer of
For example, Cell A1 (on sheet 1) contains a label. How can I get that
label to show in a header?

When saving a file, you get a popup with a suggested path. I need to find a macro that will either offer a suggested file name based on a cell's date value (a1) and a suggested path (to the desktop) for any user that uses the spreadsheet - or simply will save the file using the cell value as the name to the user's desktop.

Each user will have their own version of the file, to save to their own desktop. The macro will need to overcome the issues that each user's path to their desktop will be unique since each will have logged in to the window's session with their own profile.

Unfortunately I don't have anything to build upon yet...I keep looking and find something promising...but the code is beyond my understanding still.

Any help would be greatly appreciated.

Hi there,

I have created an excel sheet that i have locked and protected so end users cant screw it up basically. But i have it formatted nicely on my screen (i.e. i have removed unecessary toolbars/formula bar etc) so it looks tidy. But as soon as another user opens it up on their PC, all the toolbars etc keep reappearing and it looks very untidy again. Im guessing this is down to each user's preference on how they like to work in excel, but is there anyway you can customise this so you get a standard view for all users????

Would this perhaps be in the module code or something like that??

Many Thanks!


Hi there,

I have a question about Excel/subtotal function:

The row limit for a sheet is about 65000 and I have 10 sheets (1-1, 1-2 ...). I have selected all sheets and sorted the data. I would like to make subtotals for all the sheets together. However I got message that Excel can't create extra rows for any sheet, since each sheet has reached its row number limit already.

I am using Excel 2003.

Thanks for your help.

I want to use same header for multiple sheets in Excel, and only change a few
items in the header, or footer; i.e. summary of billing for separate
projects using the same content headers for the body of the sheet, but the
header changes to note a specific project. I can Copy & Paste the sheet
content and then modify from sheet to sheet; but I did not find a ay to copy
the Header & Footer from sheet to sheet without having to re-enter all the
Header/Footer info again. Can it be done??

No luck finding an answer? You could always try Google.