If you scroll through long Excel worksheets and lose track of your headers, freezing the top two rows is one of the quickest productivity wins you can apply — it keeps labels visible, reduces input errors, and makes navigation instantaneous even in very large sheets. This guide shows the...
activewindow.freezepanes
alt w f f
excel
excel desktop
excel for mac
excel for windows
excel on the web
freeze panes
header row
macro
merged cells
print titles
protected sheet
split panes
top two rows
troubleshooting
unfreeze
vba
view tab
I got a macro keypad, been trying to set it up but for whatever reason, all the shortcuts i set up in the shortcut property window just dont work, and by that i mean I make a shortcut to the exe and open up properties. The shortcuts are preset as CTR+ALT+[num], and for whatever reason any...
Hi all, in this post we will be exploring malicious PDF files and how the bad guys leverage them to infect computer systems.
I'm sure a lot of people are familiar with receiving a strange email often times seemingly from a known person containing an attachment. You open it and miraculously...
CORSAIR iCUE software connects all your CORSAIR iCUE compatible products together in a single interface, giving you complete control over your entire setup.
Synchronized lighting across all your iCUE compatible devices brings your system to life, while powerful macro control accelerates your...
Hi,
I have a Excel macro that copies a specific cell value. Is posible to execute it from another application without losing the focus?
Thanks in advance.
Regards,
Jose Luis
I have a lot of part numbers that are spread all over the network. I would like to know if there is a macro that I can use to copy and paste all these numbers and have the macro search for these numbers. Is this possible?
Hi,
I am trying to extract information from one program, then import it into Excel. Well, the format it is extracted is not the format that is what I need. So, I have been manually deleting all the unneeded rows. My question is there a macro or C-Plus program that can delete these rows for me...
automation
c++
code
customization
data
data processing
efficiency
excel
excel functions
excel tips
import
macro
programming
rows
scripting
spreadsheets
tech support
user help
workflow
I want to use the Task Scheduler to open an Excel file. The Excel file contains a macro that automatically runs when the file is opened. At the end of the routine the macro saves the file and closes the Excel application using the following commands:
>ThisWorkbook.Save
>Application.Quit
When...
I used to work with the Windows Task Scheduler every day, a few years ago; haven’t touched it in a while. So, today, I entered the appropriate info for General, Triggers, Actions, Conditions, Settings, and History. I am trying to open an XLSB file, which contains workbook open code in...
I am not much of a gamer (not good at it) and thought this might be a place to get the right answer. I needed a new keyboard and bought a Microsoft Sidewinder X4 keyboard for it's back lighting and features and have on irritation with it. The yellow (automatic profile) light comes on at random...
Hello everyone I have a microsoft sidewider x6 and I recently installed windows 8,but when I assigned my macros and tried to run my application macros didn't work what do you think is the problem?The applications I am facing the problem is tera online,aion,maxthon...
Thank you verymuch for your...
I'm trying to find something where I can set it so that when I press a button on my keyboard it will "move mouse there" "shift click" "type E" and general mouse movements/clicks and keyboard strokes.
Fixes a "Type Mismatch" error message that occurs when you run a VBA macro in a 64-bit version of an Office 2010 application. This issue affects VBA macros that run correctly in 32-bit versions of Office applications.
More...
Fixes an issue in which you can circumvent administratively-enforced AppLocker rules by using a simple Microsoft Office macro. This issue occurs on a computer that is running Windows 7 or Windows Server 2008 R2.
More...
I am using Windows 7 & office 2010. My Anti-virus program that I use is Bitdefender. From tiime to time when Opening up Excel after running a macro and get a message advising of insufficient resources. I think that Bitdefender may be causing the problem as I never had this problem before
Can...
I have the following FTP code which works perfectly on my one PC at the office. I have just been given a new PC and when running the macro run time error 440 "unable to wait for process"
The following code is highlighted
wsh.Run FTPcommand, 5, True
I am using Office 2010 and...
Usually after I have run a macro on Excel and truy to open up another workbook , I get a message "Insufficient resources" I use Windows 7 and Office 2010 and have 4GB of RAM.
It would be appreciated if someone could help me resolve this issue
Sometimes when I Open up an Excel attachment in outlook a message comes up "insufficient resources" I am using Windows 7 operating system & Excel 2007. The same problem occurs when I have several Excel files open and run a macro
I am using an Intel TM2 Duo CPU 2.93GHz and have 4GB of RAM...