opened

Hi All, I need a macro that will set calculations to manual when a sheet is opened and calculate the sheet with the Enter key. Your help is greatly appreciated!

hi all, when i opened my vba file on Windows Drive , its opened in Read-only. but other Drive its opened without any problem, how can i open vba file without Readonly on windows Drive??? thanks in advanced.

I have a file that is in a SharePoint folder and when opened from the Excel application the workbook_open code doesn't execute. When the file is open I can open the VBE and manually run it (F5 form within the code) but why won't this execute upon opening? When opened, if the yellow bar pops up...

Hello, I am looking to automate some VBA to prevent the need for users to remember to run a VBA to update the data within a workbook. I do not believe i can use task schedulers as all computers have to be turned off when not in use. Effectively what i am looking for is code that will run the...

Good afternoon :) I've written a bit of code that when my workbook is opened, it makes sure a particular sheet is visible and then activated/selected. After it has done this, it makes sure all inactive sheets are marked as xlSheetVeryHidden. The code works fine when opened up from 'My...

Hi, I would like to run macro in different file. It means I have opened file (master) where I start up the macro which will open another file and there I need to do some actions. Is it possible to write macro in first (master) file or it must be somehow writtten in second (opened) file? Thank...

I have a routine that creates a pivot chart and functions perfectly on my installation of Office 2010, however when opened and used by someone with Office 2007 the routine bombs while creating the pivot chart. The code in question is shown below...

Team, I have a table with columns... Opened - date a ticket was opened - format = dd/mm/yyyy Group - name of a group ticket was assigned to - format = [text string] Active - flags whether the ticket status is still open - format = true/false I currently have a pivot table set up, where...

Hi I am providing Customer Reports which consists of a Dashboard with no external connections but many linked tables and Vlookups. I do this for other Customers with no problem. However when I sent (emailed) the most recent report they reported that although the file opened none of the table...

i need a code to insert date and time as soon as excel file opened can you that thank you

I am running Excel 2016 with the latest updates, as is everyone else in my office. I created a spreadsheet for another engineer that will automatically calculate payment penalties for asphalt that does not meet the contract specifications per Michigan DOT standards. All of the macros and...

Hi, I should start off by stating that im pretty much a complete novice in Access, but will attempt to explain the situation as best I can. I have been tasked with creating pivot tables in excel via an external connection (an access database) I have managed to do this via Pivot Table > 'use...

hello, i have a an excel file with lot of sheet's and formulas when i add data it make calculation slower :( and i have "Calculating: (4 Processor(s)): %" at the bottom right of the workbook? if i opened this excel file on another computer with higher model and faster should the the excel...

Is there a way I can stop work colleagues from deleting rows from a file they have opened other than the rows they add after opening it? What I mean is, it is important that the data in the file when they open it cannot be deleted. I thought about creating a variable called...