Search Results for ‘macros’

I just bought a refurbished laptop and refurbished PC through a program for low-income seniors. They both came with Windows 10 and Office 2010 installed. Up to now I've been using Word 97 on an old PC running Windows XP. Over the years I created a collection of macros in Word 97, and I'm...

I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the...

Hi All, looking for help on an issue I'm having with the personal.XLSB workbook, I'll be as clear as I can. Long time users of Macros stored in an excel workbook saved in C ://users/username/appdata/roaming/microsoft/excel/xlstart Stating the obvious this workbook should open hidden but make...

I cant, i just cant... I want to make a toggle macro for shift. I watched some videos on youtube and they all tell me to click record then hold the key and then press again to end the macro but i cant it doesnt let me click it until i release the key!! Seriously what is this !!?? So pls if...

Hi everybody, First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software. I seen current thread that were very close to what I need but was unsuccessful with...

Hello, I've been online all day trying to find more info on creating an excel spreadsheet with VBA scripts to send an email when there is an upcoming due date. I'm trying to learn about macros and VBA scripts, but I've never learned how to code and this stuff looks very dense. In this...

Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...

Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...

I am trying to figure out how to set Excel up to automatically unlock tabs after data is entered. Ex: I enter data in cells on sheet 1 and sheet 2 is locked until all data fields are entered in sheet 1. Sheet 3 stays unlocked until all data fields in sheet 2 are entered, etc. I know...

Good day, First I'd like to say...This site is a great learning resource! Learned so much about VBA and Macros in just two days. Now the issue. I found two great codes that I will 'splice' together to get what I want...

Good Morning, I am attempting to create a print preview, and then a printing button for one of my documents. I figured out how to do a basic print preview and then print when approved. If possible, I would like to create 5 copies (currently just pressing the button 5 times) and on each...

Hi everyone, I read a post on Tech Support Guy that was similar to my question however seeing as the thread was quite old, I thought I would ask again to see if there were any new ways of doing this. I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number...

Background: We have a weekly meeting that we all sit around and dish out our schedules and manually input them into a master excel sheet. This is inconvenient, time consuming, and inefficient. We would like to automate the process. What we need: Outlook Calendars (7 in total) -> Master Excel...

I'm receiving the following error when trying to run a recorded macro: "Run-time error '1004': Cannot use that command on overlapping selections." It was successful when I recorded it, but when I tried to run it on a new sheet, I received the error. My code: Sub Sub_and_delete_blanks()...

Hi everyone, I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its...

I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for...

Hi So basically I'm very new to macro and have no idea! My boss has asked me to find a way to make a word document do the following: Have a check box to click - when clicked this will copy in a bunch of text from another document saved on our server/(insert text from file). Then when unchecked...

(This is my first posting) I'm very far from being macro knowledgeable, however, I did create two small macros that I would like to run on all worksheets, rather than just the active worksheet. And if possible, I'd like them to be the same macro, however, they seem to only work as two separate...