opens

I have a sheet and when you click on cell B4 a multipage userform opens. I was able to get the page captions to reflect a particular cell (i.e. Page1 = B4, Page2 = B5...) but they only change once you click on the page. So when the form opens it first says Page1, but when you click it, it...

Hi All When settings like, View Zero Values are customized, will they be preserved when a user on a different computer opens the file? Thank you!

I have it so that the userform only shows when "XYZ" is selected from a drop down in B2. But now even after it is satisfied if I select any other drop down in any other cell of this worksheet the userform opens again. I only want it to open if "XYZ" is selected from B4. Private Sub...

Hi I've got the code below which opens the "Downloads" folder on my laptop, after which I choose a file to import. However, I'd like to modify the code so that it opens the CURRENT folder that I'm in. E.g if the files I'm using are all saved in "My Documents", then I'd want the code to go...

My formula in cell A1 says: =HYPERLINK(A2,A3) Cell A2 has the URL Cell A3 has the name of the website. And it works, if I click on cell A1 it opens the internet and my target website appears (-: But my test macro to do that doesn't )-: Sub SelectHyperlinkCell() ' ' SelectHyperlinkCell Macro '...

Hi All, Any help appreciated I have a Excel file, which contains VBA, Userforms etc - everything works fine.... However when anyone opens it, as it sits on SharePoint (I think that is why it does it) it opens in read only and you have to click the "Edit Workbook" button in the ribbon. Can...

I run a macro to open a file, copy and paste info, then close the file. sometimes I noticed it mysteriously opens itself open again....hows this possible>?

Hello, I have this excel file that is in a shared drive, sometime this file will not open or will crash trying to open, but when another co-worker opens the file (yes they can open it) and saved the file with another name then it will work for me. Any ideas why this could be happening? Thanks!

Hi, I'm trying to keep track of who opens an excel workbook and the date. I have some code here to identify the user: Public Function UserName() UserName = Environ$("UserName") End Function This is a good start but a single cell is not a good solution because I would always just see me as...

So I am an analyst and I automate over 150 reports to people all over my company. I suspect that many people do not use the reports that I send and I would like to know which reports are not used so that I can turn them off. Basically I am looking for VBA that will notify me, or maybe update a...

Hi, My company moves us the Office 365 and I have developed an issue. I have a personal workbook that has several macros in it and when I open another excel file the personal workbook opens first the the selected one opens. The issue I would like to fix is when the requested file opens it...

When I open excel it opens 5 worksheets: Book, Personal, Personal1, Persona, Job List. How can I stop it from doing that.

Hi, In cell K33 i have pasted the following code. =SUM('INCOME (1)'!G32 -'EXPENSES (1)'!K32)-MILEAGE!C32 When i then hit enter *** opposed to see the code apply itself & return a value the browser tree opens and advises me to update value income 1 Whats happening ? Thanks

Is it possible to force a worksheet to always open to a specified size and location and not influence the next worksheet that opens?

Hi Everyone I have this code that hides tabs, headings, gridlines for the sheet i'm on but I'd like it to run on everysheet when the document opens how can I change this so instead of "activeWindow" it say "Every Sheet"?? Sub Full_Screen() Application.ScreenUpdating = False...

Have 2 versions of Access installed on my computer. One of them is not working probably. Have created to open an access database. Unfortunately, it opens it with the access application that does not work. How can I setup that it opens with the access application that work. (It is not...

Hello All- Everyone has been fantastic helping me build (and learn) VBA on this new workbook. It's been great- now I've run into an issue that i don't readily see. I have 5 userforms. Userforms 1, 2, and 3 open (Workbook_Open) based on one of three names of the workbook- Irregardless of...

Hello Everyone, hope someone can help In an Excel workbook I have VBA code which copies various cell data from a "Summary" Worksheet on multiple workbooks which are filled in by multiple other users, the code opens, gets the data from the summary and closes each workbook in turn and cycles...

Hi everyone, I have a workbook that a macro opens, saves, and information is pulled from that excel. Problem is: the Workbook will not update while macro is running. The worksheet opens, everything is 0 and then it saves as everything 0. When I leave it open after macro finishes, it will update...

Hi, Very small issue but it annoys me...if I type a password in correctly, a new book opens, which I then have to close. I can't see anywhere in options to disable this...can it be (disabled)?