How to enter last saved date in Excel workbook
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
Sheets(“Sheet1”).Range(“A1”).Value = Now
End Sub
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
Excellent guide on creating a text watermark and actions here
After new installation of Windows 7 folders and files were locked and admin permission was required even though account in use was admin. Work around: First switch of UAC – user account control. Technet forum Here’s how I edit the C:WindowsSystem32driversetchosts file. It gave “You don’t have permission to save in this location..” but I solved…
I was having difficulty with Windows 10, the start menu was “sticky” it would need a few clicks to bring up the menu, also Cortana would not work when clicked on and when typing in the start menu. I found a working solution here: CTRL+ALT+DEL Click on task manager Then in the task manager menu…
Copying from bank statement, issue with all the date copying to a single cell and not into individual cells. The tedious workaround was to copy into MS Word and add a semicolon (or other) after each cell data. Then copy the date to Excel then: Data > Text To Columns > Delimited > ; > Finish I…
I had some issues with Kaspersky AV and Outlook 2010. I launched Outlook in safe mode by holding ctrl and then launching Outlook – didn’t solve my issue but something new for me.
I downloaded and installed the drivers for my Netgear WNA3100 usb adapter, inserted the device when prompted, nothing happened for a while. I searched online (ethernet cable plugged in) and found that the feature needs to be enabled: Go to Server Manager -> Features -> add a feature -> scroll to the bottom- > select…