Opening Popup When Spreadsheet Opens.

Dec 20, 2006

I was wondering if you can make a popup open when a user opens a spreadsheet. I have some templates i made and users continue to make the same mistakes. I was hoping to add a form/pop so when the file was opened a popup would come up with reminders. Once they press ok they can proceed.

View 3 Replies


ADVERTISEMENT

Workbook Automatically Opens When Opening/Closing Any Other

Mar 14, 2008

I have a problem, where every time I close or open any workbook, Excel prompts me to "Enable or Disable Macros" in one particular workbook, wether I have tried to open it or not. In the said workbook, I have a macro that automatically updates a pivot table upon selecting the worksheet where the pivot table resides.

The code for it is as follows:

Sub UpdateIt()
Dim iP As Integer
Application.DisplayAlerts = False
For iP = 1 To ActiveSheet.PivotTables.Count
ActiveSheet.PivotTables(iP).RefreshTable
Next
Application.DisplayAlerts = True
End Sub

Private Sub Worksheet_Activate()
Call UpdateIt
End Sub

There is something in the code that calls UpdateIt any time a workbook is opened, closed or selected.

View 3 Replies View Related

Opening Saved File Also Opens Blank Workbook

May 3, 2013

When I open any saved Excel file the saved file opens along with a blank workbook titled "Book 1". How can I make it so when I open any saved Excel file it only opens the file I want and not a new workbook every time?

View 2 Replies View Related

Excel Opens Multiple Workbooks When Opening Any Workbook?

Jan 27, 2005

The same two workbooks open when I open any other workbook. They also open up when I open Excel by itself.

View 9 Replies View Related

Opens Spreadsheet Twice

Dec 24, 2008

When I double click an excel spreadsheet in windows explorer it opens spreadsheet then closes it then opens it again.

This doesnt happen if I have an instance of excel already running.

I thought it might be to do with file association and the open with option.

View 9 Replies View Related

Tracking Who Opens Spreadsheet

Dec 19, 2007

I have a spreadsheet that can't be password protected but this doesn't mean just anyone should be accessing it. Is there a way to record who opens it and when? Ideally I could place some code into the spreadsheet that recorded on a sheet who has opened it and when. This will detract certain nosy people from accessing it!

View 9 Replies View Related

Popup If Condition On Spreadsheet Open

May 18, 2007

I would like to have a popup appear on the opening of my spreadsheet that warns me of things that are past due or due today. I would like it to be in list form...

For example my source is:
Customer 1 Customer 2
Topic Expected Complete Expected Complete

One 05/18/2007 05/10/2007
Two 05/12/2007 05/15/2007 05/18/2007 05/18/2007
Three 05/12/2007 05/17/2007 05/16/2007
Four 05/21/2007 05/17/2007

What I would like to see is a popup that analyzes this data with the result of:

If run today...5/18...................................

View 14 Replies View Related

Opening OpenOffice Spreadsheet In Excel?

Mar 22, 2013

Is it possible to open an OpenOffice spreadsheet in Excel while keeping all formulas?

At the minute when I try this, Excel just opens the spreadsheet with the values of each cell from OpenOffice (the results of the formulas) and not the actual formulas themselves.

View 1 Replies View Related

Opening Spreadsheet With Varying Names

May 15, 2014

I am working on a personal macro that is lauched from a file that is produced on a weekly basis resulting in a filename that changes every week due to a date range that is in the file name (ex. Weekly Accounting 04_16_14 to 04_22_14.xlsx), for this example I will call this "Spreadsheet A". When working with this spreadsheet I open another spreadsheet ("Spreadsheet B") to retreive data and I then need to go back to Spreadsheet A again to paste this data. The problem I have is I don't know how to go back to Spreadsheet A since the name changes each week and I cannot hard code the name into the coding. I usually use Windows("Random Spreadsheet.xlsx").Activate to go between spreadsheets, but in this case I cannot.

Is there something that will allow me to return to Spreadsheet A no matter what it is named?

View 3 Replies View Related

Making A Spreadsheet Smaller On Opening

May 16, 2007

I have a 30 in monitor (I know I'm lucky!) but when I open a new spreadsheet it opens all the way across the screen 100 columns and 100 rows. How can I change the size when it opens?

View 9 Replies View Related

Prevent Spreadsheet From Opening When Being Updated

Jun 19, 2007

I currently have a spreadsheet that my deparment use at work. Its just a full time equivallent sheet, nothing fancy. However I added code onto it to prevent users opening it as I was updating it.

However I went to open it and It wouldnt open. It wouldn't recognise me as being the exception. Its just a code on the workbook open that says if user is "slb090" (which is me) then do nothing, else msgbox and just a quickie sayign come back later".

I have attached the spreadsheet, in the hope someone can open this for me and remove the message so I can open it!

View 3 Replies View Related

Code That Copies A Range Opens Notepad Pastes The Range Opens Save Dialog And Types The File Name

Nov 6, 2009

I currently have the following code that copies a range opens notepad pastes the range opens save dialog and types the file name. The problem I have is with overwriting the existing file.

Range("A1:A202").Select
Selection.Copy
Shell "notepad.exe", vbNormalFocus
SendKeys "^V"
SendKeys "^s"
SendKeys "Total_IEDs_Hour_Of_Day_2009.xml"
SendKeys "{TAB}"
SendKeys "a"
SendKeys "{ENTER}"

Everything works fine to this point. Then it opens the do you want to overwrite dialog and I cant get it to hit yes.

View 9 Replies View Related

Data Validation Disappears When Re-opening Spreadsheet?

Aug 23, 2013

I add data validation into 4 columns and when i re-open the spread sheet after saving it, it clears all validation.

Although it clears the validation, the place where it gets the data from is still there. i have also unfroze panes and is still clearing data validation

Attached is the spread sheet. The data validation is in columns A, G, H and I on the 'unsourced' page and is getting the data frfom the 'Sheet1' Page.

View 2 Replies View Related

Message Box On Opening Of Spreadsheet - Option To Run Macro Or Not

Nov 9, 2012

I Have a tool which will be used online & offline.

I would like a box to appear on the opening of the spreadsheet which asks the user "Are you online?", with options "Yes" & "No", if the user selects "Yes" then a macro (which i have already written) refreshes the spreadsheet.

if the user selects "No", the sheet is not resfreshed.

What is the best way to do this?

View 2 Replies View Related

Disable Password Prompt Upon Opening Spreadsheet

May 29, 2008

have a password protected spreadsheet with a userform for people to enter data. This allows them to enter data, but stops them from editing or deleteing data once entered.

When the spreadsheet is opened, it asks for a password to unlock it. Hitting cancel allows the user to continue and the userform pops up for the user to enter data. I would like to disable the initial password prompt when the file is opened to avoid confusion on the users part.

View 9 Replies View Related

Opening My Spreadsheet Which Will Only Open If The Correct Answer/ Password Is Typed

Apr 22, 2009

upon opening my spreadsheet which will only open if the correct answer/ password is typed.

I’d need to store the questions, passwords/ answers somewhere for VB to look up I guess??

Capital of England – London
Capital of France – Paris
Capital of Italy – Rome

Etc etc

And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.

View 9 Replies View Related

Opening A File Without Opening A Workbook

Apr 17, 2007

I have a need to open a file from my companies intranet. My current method was to open said file via the method that the recorder gave me. However, I would like ot be able to open a said file without having to start open another workbook.

This is the path:
[url]

So the command is this:
Workbooks.Open [url]

Links are not actual links

So what I need to know. Is how can I open this file without opening a workbook. I haven't been able to use the VB "Open Statement" to open a file and I don't believe that I've been successfull using the Filesystem object either.

View 9 Replies View Related

Run Sub When Worksheet Opens

Apr 24, 2007

I have a date displayed in a controlbutton caption that fails to refresh each time the worksheet is opened.

Q1: How do I run the sub below each time the user opens the worksheet?

Q2: Is there a better way to clear the contents of a textbox?

Private Sub ClearForm_Click()
ActiveSheet.Unprotect
ActiveSheet.Range("C4,C6,C8,F4,F6,F8,F25").ClearContents
ActiveSheet.Range("I4").Value = 0
ActiveSheet.Shapes("Text Box 12").Select
Selection.Characters.Text = ""
MailDate.Caption = Range("H11").Value
ActiveSheet.Range("F4").Select
ActiveSheet.Protect
End Sub

View 9 Replies View Related

Run When Workbook Opens

Oct 4, 2008

How do I run this I can not get it to work I keep getting errors this is the way I have it for now.

Private Sub ThisWorkbook_Open()
MY_MONTH = Month(Now()) + 5
With Sheets("Master List")
.Unprotect ("123")
.Columns("A").Locked = False
.Columns("A").Hidden = True
.Columns("T:IV").Hidden = True
.Rows("265:65536").Hidden = True
.Columns("E:Q").Locked = False
.Columns("E:Q").Hidden = True
.Columns(MY_MONTH).Hidden = False
.Columns(MY_MONTH - 1).Hidden = False
.Columns(MY_MONTH - 1).Locked = True
Dim ws As Worksheet
For Each ws In Sheets([{"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","2008","Read Me","Record"}])
With ws
.Protect ("123")
End With
Next
End Sub
Compile error: Expected End With

View 9 Replies View Related

VBA That Opens Excel In New Window

May 3, 2014

I have a project were i have to make a macro and place in a workbook such that as soon as i open that excel file

1. excel workbook is opened in New Excel window
2. Ribbon is hidden for this new window.

So when user closes this excel window there is no problem with other workbook ribbon, as there are open in different window

I have tried with code stated below it hides the ribbon but new excel window is not open

Private sub Workbook_open()
Application.ExecuteExcel4Macro "Show.toolbar(""Ribbon"",False)"
End Sub

View 2 Replies View Related

Randomize When File Opens

Sep 14, 2009

This is a follow-on to a great solution provided by Shg and Rylo. Here is the link. http://www.excelforum.com/excel-prog...new-sheet.html


My users have run in to an interesting issue with the file. Each time the files opens it has the same 5 questions selected. What I need the code to do is randomize the questions each time the sheet is opened. Basically, the users seem to have a problem using the "make quiz" button, so they have requested that I make sure that the quiz randomizes each time it is opened.

View 7 Replies View Related

Options When Workbook Opens

Jan 31, 2010

I would really like to know if there is a way that when my workbook opens if the following can happen?

- Not display the tabs (NOT "HIDE" the sheets, just not be able to view the tabs themselves)
- Go to full screen (not display ribbon)

View 6 Replies View Related

Autofilter When Workbook Opens

Jul 16, 2008

My workbooks contains 2 worksheets with data and autofilters on for each column in use.

When my workbook opens I am trying to reset the autofilters of each worksheet in the workbook and to filter the data according to one criteria in one column.

This is what I have that works to reset each worksheet but I haven't been able to figure out how to subsequently filter each worksheet.

Private Sub Workbook_Open()
Application.ScreenUpdating = False
For Each w In Worksheets
w.Unprotect
If w.FilterMode Then w.ShowAllData
w.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True
Next w
Application.ScreenUpdating = True
End Sub

The autofilter sits in A3 to N3 and I am trying to filter according to column M (i.e. 13th column)

View 9 Replies View Related

Add-in Opens Workbook It Was Created In

Oct 27, 2006

I've created an add-in that runs a simple macro. The problem I have is that when I run the add-in it opens the workbook I originally created it from - is this what I should expect it to do? How do I stop this from happening?

Also, do I need to have the workbook from which I created the add in located in the same place on every machine I want to use the add in on? At the moment if I move the original workbook the add-in won't work.

View 9 Replies View Related

Run A Macro When Worksheet Opens

Feb 1, 2007

I have worksheet with a macro and currently if I run the macro using the play button and then select the macro it runs fine but what i want it to do is run when i open the workbook automatically.

View 3 Replies View Related

Select The File And Opens

Feb 28, 2007

I have a function which selects a file and opens it.It is part of a code.

Sub Cpy()
' Macro recorded 1/16/2007 by PZCHFR
Set PresentWorkBook = ActiveWorkbook
FSel
Findlastusedrow
Cpy_Name
getmonth

End Sub

Function FSel()
filetoopen = Application. GetOpenFilename("Document Files (*.xls), *.xls", 1)
'Workbooks.Open Filename:=filetoopen
'Set OpenedWorkBook = Application.Workbook(filetoopen)
Set OpenedWorkBook = Workbooks.Open(Filename:=filetoopen)
End Function

When the user does not select any file and clicks "cancel" in the dialog box,this gives me runtime error .How do i make the code correct so as to handle the case where there is no file selected.

View 4 Replies View Related

Conditional Macro When Excel Opens?

Sep 28, 2013

I want to run a VBA macro when Excel opens if and only if the file name contains a specific string or if and only if the worksheet name contains a specific string. The file only contains one worksheet. For example, if the file name contains the string "SalaryData" or the sheet name contains "SalaryData", then I want to run a VBA macro to delete some of the confidetial information. Idealy, this would be done as the file is opening before it is displayed.

View 1 Replies View Related

Excel 2010 :: Opens New Instance For Each Fie

Dec 12, 2012

In the last couple of weeks my copy of Excel 2010 has started acting strange. Now when I double click an xls or xlsx file in Windows Explorer, it tries to open a new instance of Excel, whic means that it tries to reopen Personal.xlsm and Personal.xlsb, and finds they are already open, so it gives me an error message. Previously it perfectly happily opened the document in another window in the same instance, which is presumably much more memory efficient quite apart from the file locking problem mentioned. How do I get it back to the way it was before? Is this another of MS's famous overnight downgrades?

View 2 Replies View Related

Set Focus To A Textbox When Userform Opens

Jul 29, 2009

I'm creating a userform for editing membership records of a small organisation. So I want the focus to default to textbox tboxFind which is used for searching the data.

I've put tboxFind first in the tab order, and in subroutine Userform_Initialize, the last line is tboxFind.SetFocus

Using Excel2000 on Windows Vista, it works OK.

Opening the same workbook in Excel2000 on WinXP, no textbox has the focus when the form opens, but once the user has started to use the form, the focus defaults back to tboxFind, as it should.

So why is the focus not where it should be when the form opens in WinXP?

View 11 Replies View Related

Stop The Calculations When The Workbook Opens

Nov 24, 2009

I need to stop the calculations when the workbook opens. I have tried

View 2 Replies View Related







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