|
||||||||
Can somebody make me a "clash detector"? |
![]() |
|
|
Thread Tools | Search this Thread |
|
|
#101 |
|
Forum Member
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
|
Quote:
The option is in Excel itself.
In Excel 2003, it's under Tools | Macro | Security. Change to Medium Security Level, and it will then ask you each time if you want to run Macros; obviously say yes to allow Graham's application. This is safer than Low, which will run all macros, even those you don't know ![]() You can actually specify more than one folder as being trusted, but what I do is to have a single folder in which I store all Excel files with macros that I trust. I then create shortcuts to the files in the (untrusted) folders that I would have stored them in if it wasn't for the macros. |
|
|
|
|
Please sign in or register to remove this advertisement.
|
|
|
#102 |
|
Forum Member
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
|
Quote:
If you are using Excel 2007 (not sure about other versions) there is another option available. From within Excel, you can specify a particular folder on your PC as being trusted. Any excel file containing macros opened from that directory will open seemlessly.
If anyone knows how to do this, it would be useful here. The other way of doing it is for the author to digitally sign the macros from within Excel, and then when you open the Workbook with Security Level Medium, you can get the option to add the author as a Trusted Publisher. But to do this, I think the author has to obtain a Digital Certificate, which I don't think are free ![]() Rgds. Les. |
|
|
|
|
|
#103 |
|
Forum Member
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
|
Quote:
The "Very High" Security Level within Excel 2003 "appears" to offer a "trusted locations" option, but when you select this, it doesn't seem to offer the option to specify the location. I've tried looking in the Help, but it's not much use in this respect.
- "Trusted locations" where you can manage trusted folders including adding new ones, and - "Macro Settings" where you can chose what Excel does about macros in files not in a trusted location. I have this "Macro Settings" set to "Disable all macros with notification". With this setting Excel will let me chose what to do about macros for files stored in a "normal" location and open files in trusted locations with macros automtically enabled. |
|
|
|
|
|
#104 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
Graham, there are no http links
![]() Rgds. Les. Here they are (hopefully )http://www.4shared.com/file/10021431...ableWatch.html http://www.4shared.com/file/10021432.../OneCable.html http://www.4shared.com/file/10021434...leSuggest.html http://www.4shared.com/file/10021437...ableWatch.html http://www.4shared.com/file/10021439.../TwoCable.html http://www.4shared.com/file/10021441...leSuggest.html Graham Last edited by grahamlthompson : 22-04-2009 at 12:00. Reason: typo |
|
|
|
|
|
#105 |
|
Forum Member
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
|
Quote:
With Excel 2007, you get to it by selecting "Excel options" followed by "Trust Center". Pressing the "Trust Center Settings" button brings up the "Trust Center" window. From here you can select a number of options. The ones relevent here are
- "Trusted locations" where you can manage trusted folders including adding new ones, and - "Macro Settings" where you can chose what Excel does about macros in files not in a trusted location. I've got Office 2007, but when I installed it for my daughter on her PC, I really didn't like the interface at all, I couldn't intuitively find my way around it, and I don't do manuals ![]() ![]() ![]() I'll stick with 2003, and it really isn't that much effort to press the "Run Macros" button when opening the file. Rgds. Les. |
|
|
|
|
|
#106 |
|
Forum Member
Join Date: May 2002
Location: Crystal Palace
Posts: 958
|
Quote:
The other way of doing it is for the author to digitally sign the macros from within Excel, and then when you open the Workbook with Security Level Medium, you can get the option to add the author as a Trusted Publisher. But to do this, I think the author has to obtain a Digital Certificate, which I don't think are free
![]() Comodo offer free Digital Certificates for email, I don't know if it could also be used to sign macros - http://www.comodo.com/products/certi...ces/index.html The signup page does mention X509. |
|
|
|
|
|
#107 |
|
Forum Member
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
|
Quote:
I've got Office 2007, but when I installed it for my daughter on her PC, I really didn't like the interface at all, I couldn't intuitively find my way around it, and I don't do manuals
![]() ![]() ![]() |
|
|
|
|
|
#108 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
I hated the Office 2007 interface when I first installed it, but I was updating from Office 1997 so I stuck with it. It took me a long time to get used to it (I also don't do manuals) but, now that I have, I find it a lot quicker to navigate than 1997. I doubt if there would be a lot of point in upgrading from 2003, though.
|
|
|
|
|
|
#109 |
|
Forum Member
Join Date: Aug 2008
Location: Somerset. UK
Posts: 102
|
Quote:
Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)
http://www.microsoft.com/downloads/d...displayLang=en |
|
|
|
|
|
#110 |
|
Forum Member
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
|
Quote:
Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)
If you get a .xlsx file from someone, ask them to send it again as .xls. It should be easy enough for them to do. |
|
|
|
|
|
#111 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
It may not be the VBA code that's the problem, but the way in which the spreadsheet was saved. Excel 2007 has its own format (.xlsx) which it will default to. Even the simplest of spreadsheets saved as a .xlsx file won't open in earlier versions. Excel 2007 does have a "Save as Excel 97-2003 Workbook" option (which can be set as the default). This saves to .xls format. If there are functions in the workbook that won't convert to .xls, you will be warned. I always save to .xls if I'm sending the file to someone and I've had no problems with speadsheets containing VBA code. Most of the issues I've seen have been cosmetic.
If you get a .xlsx file from someone, ask them to send it again as .xls. It should be easy enough for them to do. |
|
|
|
|
|
#112 |
|
Forum Member
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
|
Quote:
It was a .xls file, I could open it and run the code but not view it or edit it any way
|
|
|
|
|
|
#113 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
OK. I thought you were saying that you couldn't open the file or use it in any way. The .xls version of the code is obviously 2000 compatible otherwise you couldn't run it. Odd that 2000 won't display the code for editing. I assume you have the VBA plugin installed. [Note: Not quite sure whether that's what it's called, or whether it's relevent to 2000. What I'm remembering is that, with '97, the VBA editor was a seperate component which was not installed by default.]
|
|
|
|
|
|
#114 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Minor Mod
Talk Sport radio added to record clash app - no change in download link
|
|
|
|
|
|
#115 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Record Check 10 update
2 channels deleted and channel 205 transponder change - link unchanged
|
|
|
|
|
|
#116 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Record Check 10 update
Todays changes uploaded
142 BET HD added 401 Name Changed to Wedding TV Asia (was Wedding TV + 1) 801 Price Drop TV transponder change No change to link |
|
|
|
|
|
#117 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Bet Hd Rip
Auto channel scan just removed BET HD. Record Check10 updated, DIY mod
Delete ROW 31, change Cell E1 to 148 |
|
|
|
|
|
#118 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
New Version 11
With thanks to Savvy who spotted some inconsistency in the results.
For both single and dual options programme incorrectly identifies channels 208, 513 and 801 as viewable with ITV HD as one of the recordings Similar bugs in single cable and dual cable suggestion and what can I watch fixed West Country (Exeter) post code now default due to ITV1 picture quality For anyone interested the problem was due to ITV HD having the same transponder frequency but differing polarity to some channels on Astra 2. http://www.4shared.com/file/11660217...dCheck011.html |
|
|
|
|
|
#119 |
|
Forum Member
Join Date: Jun 2004
Location: Nottingham
Posts: 372
|
Found a bug in V11.
Select Dual Cable Select First Recording = 108 BBC HD Select Second Recording = 101 BBC 1 E Mids Click on Alternate Watch Options The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required. I am in the East Midlands, so my first four rows are as follows:- 101 BBC 1 E Mids 10788 V 102 BBC 2 England 10773 H 103 ITV HD (red button) 11426 H 103 ITV1 Central E 10832 H Geoff |
|
|
|
|
|
#120 |
|
Forum Member
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
|
Quote:
Found a bug in V11.
Select Dual Cable Select First Recording = 108 BBC HD Select Second Recording = 101 BBC 1 E Mids Click on Alternate Watch Options The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required. I am in the East Midlands, so my first four rows are as follows:- 101 BBC 1 E Mids 10788 V 102 BBC 2 England 10773 H 103 ITV HD (red button) 11426 H 103 ITV1 Central E 10832 H Geoff I think there are too many permutations with all the Regional BBC1 channel options. I think we had this in one of the earlier versions, and Graham put a limit on the output. I'm sure he'll be along soon. Rgds. Les. |
|
|
|
|
|
#121 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
Found a bug in V11.
Select Dual Cable Select First Recording = 108 BBC HD Select Second Recording = 101 BBC 1 E Mids Click on Alternate Watch Options The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required. I am in the East Midlands, so my first four rows are as follows:- 101 BBC 1 E Mids 10788 V 102 BBC 2 England 10773 H 103 ITV HD (red button) 11426 H 103 ITV1 Central E 10832 H Geoff |
|
|
|
|
|
#122 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
If you leave it for a while, it comes up with a VB overflow message, you don't have to End Program.
I think there are too many permutations with all the Regional BBC1 channel options. I think we had this in one of the earlier versions, and Graham put a limit on the output. I'm sure he'll be along soon. Rgds. Les. |
|
|
|
|
|
#123 |
|
Forum Member
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
|
Quote:
Found a bug in V11.
Select Dual Cable Select First Recording = 108 BBC HD Select Second Recording = 101 BBC 1 E Mids Click on Alternate Watch Options The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required. I am in the East Midlands, so my first four rows are as follows:- 101 BBC 1 E Mids 10788 V 102 BBC 2 England 10773 H 103 ITV HD (red button) 11426 H 103 ITV1 Central E 10832 H Geoff |
|
|
|
|
|
#124 |
|
Forum Member
Join Date: Jun 2004
Location: Nottingham
Posts: 372
|
Yes, that works fine now.
Thanks for the fast response. Geoff |
|
|
|
|
|
#125 |
|
Forum Member
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
|
Quote:
Les I have sorted it out it works now I think same link.
Rgds. Les. |
|
|
|
![]() |
|
All times are GMT. The time now is 09:35.







)