2
votes
1answer
643 views

How to copy the network path of the open workbook in Excel 2007 to the clipboard?

I want to write a VBA function for Excel 2007 (as well as Word 2007 and powerpoint 2007) which: copies the complete network path of the open workbook or file to the clipboard. I'm working a lot ...
2
votes
3answers
2k views

How to store VBA Macros for Office 2007 to have them always available and share them with others?

I have created some useful VBA macros for Word, Excel Outlook and PowerPoint 2007. Now I want to have them always available in the corresponding application via keyboard shortcut or icon to click ...
1
vote
1answer
98 views

Disabled VBE command bars

While working with an Excel 2007 VBA addin (.xla), suddenly all the VBE command bars (Main menu, Edit, Debug , ..) have turned gray. I can no longer do things like insert files, block comment code, ...
0
votes
2answers
747 views

Default line spacing in Powerpoint 2007

I want to set the default line spacing in Powerpoint 2007 to 1.1 rather than 0.8 which Microsoft has set as default. Is there any way to do this? Alternatively, I could also manage if I could create ...
0
votes
1answer
410 views

visual basic save failed due to out of memory or disk space

I'm editing a macro in Word 2007 in Windows XP. When I try to save this macro, I get the following error message: save failed due to out of memory or disk space Now, I have plenty of disk space ...
1
vote
1answer
2k views

Getting VBA error when opening Excel 2007 on new computer

I have a user with a new computer that whenever Excel is opened gives the error message Opening the VBA project in this file requires a component that is not currently installed The message is ...
1
vote
4answers
13k views

Excel 2007 | Remove blank fields from pivot tables

Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them? One workaround I used was to select the blank field, right click | ...