opened

I have a UserForm that pops up when the Sheet is opened for the first time. The UserForm only contains instructions and an "OK" button that makes the UserForm unload. The only problem now is that the UserForm will be popping up every time the sheet is opened. Is there a way for the User Form to...

Hi I am trying to copy a sheet to an external file (not opened). The code below did not work. Any help would be appreciated. Thank you. If that possible, can I also decided where to put the sheet (i.e. before the last one, after the first one etc) Sub copytoexternal() Dim x As Workbook...

Good morning Gents. The following macro attempts to open a new file, take the name of a already opened file and then, save the new file with a variation of the existing file name. ============================== Private Sub CmdB_Invoice_New_Click() CurrentfileName = ActiveWorkbook.Name...

I have a Split form where the table format is shown on the bottom half of the form. Is there a way to "autofit" or size the columns size when the form is refreshed or opened?

Hi Is there a way to close a specific file that may be opened by one or more users on different computers?

Hi The below module will open an .xlsx workbook within a given path directory. FYI, I have used Public Constants to give a value to theSource_Template_Folder_Path and Source_Template_Name Dim Template_name As String Template_name = Source_Template_Folder_Path & Source_Template_Name &".xlsx"...

Hello, I have a Macro launched automatically every x minutes that refreshes a couple workbooks stored on a SharePoint site. It opens every workbook in a new Excel Instance (not simultaneously) via the Shell function, so that if one instancefails (for example an error message popping), the other...

hi all. my question is: How To load a Excel File (a Macro) when Excel is Opened? i want load a custom Ribbon, always and i think is the uniqe way... i am reading: http://www.rondebruin.nl/win/s2/win001.htm Any ideas? thanks

Hello all, I have a workbook with many sheets and manual calculation is default by other VBA trigger. I am in need of code that will calculate a sheet when it is opened and also other sheets that are linked to it as well. Example: I open sheet 1. Sheet 1 calculates. I also want sheets 3,5and...

Hi, As per the title, the below code is not executing when I open the workbook. Sometimes it executes as intended and other times it doesn't. Can anyone suggest a reason why and offer a solution please. The workbook has password protection and is used by other people in my workplace so for...

A B C <tbody> OPENED DATE CLOSED DATE TOTAL DAYS </tbody> LOOKING FOR FORMULA TO COUNT TOTAL DAYS (C2) (INCLUDING WEEKENDS AND HOLIDAYS), BETWEEN TODAY () MINUS OPENED DATE (A2) AND STOP COUNT (FREEZE) ONCE CLOSED DATE IS...

I need a WB to auto_close after Scheduled Tasks opens it but stay open when a user opens it manually. Is there a way to determine via VBA when a WB was opened by tasks (or, looking at the problem from another angle, not opened by a user)?

Hi all i have a sheet with lots of charts on it. I would like to choose/select charts then send via email. They will be to different recipients & will be different charts, i can select email address when this is opened in email so no need to put them into vba. anyone have any idea on vba to do...

Hello! Every now and then, completely randomly, Excel changes itself to Manual Calculations. There's no telling what workbook it will happen on or when. I've had it happen on a workbook that was operating fine until 2 minutes ago, then - POOF - it's now on Manual. I've searched this site and...

On my home computer, I'm running Windows 7 and Office 2010 and at work we have Windows 10 and Office 2013. I wrote a user form on my home computer that opens as soon as the workbook is opened. Here's the problem, while the userform is opened I'm still able to open other workbooks on my home...

Hi I have a worksheet [report] which has defining content in column A, e.g. A1 - 5 A2 - 5 A3 - 7 A4 - 8 A5 - 8 etc I need to have a new worksheet opened for each (5,7,8) and the content placed in row 10 of the tab. Please, can anyone help? Regards Small Paul.

Hi ALL, Can anyone help me with this? I opened Excel and received this error message: Before this happened I installed Office 2016 64bit Thanks for any help!

Hello Sir, I need to know how can I login into the following website using vba. following is the website; firstly I have to open/navigate the following web. Once it is opened I need to click login page . https://www.tdscpc.gov.in/ regards, motherindia

Hi, Help! Please. How can i insert .cls once i opened my excel file. I need the automation of the excel once it's opened. Thanks, Zaldy

Hi guys, I need a VBA to enable the use of expanding / collapsing groups in protected work sheets. Not all work sheets have groups or protection, I'm not sure if that makes any difference. I have tried a few codes from google searches some required a password when the workbook opened which...